1. Tables and Views
  2. PSC_LNP_FEE_LINE_MAP

PSC_LNP_FEE_LINE_MAP

This table contains license and permit fee line mapping.

Details

  • Schema: FUSION

  • Object owner: PSC_PER

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_LNP_FEE_LINE_MAP_PK

AGENCY_ID, RECORD_TYPE_ID, FEE_SCHEDULE_ID, FEE_SCHEDULE_LINE, MAPPING_TYPE, FIELD_NUM, LAYOUT_VERSION, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments Status
RECORD_TYPE_ID VARCHAR2 30 Yes This column is used to indicate record type id
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
TARGET_OBJECTNAME VARCHAR2 200 To store object name for complex type array
FEE_SCHEDULE_ID VARCHAR2 20 Yes This column is used to indicate fee schedule id Active
SOURCE_OBJECTNAME VARCHAR2 200 To Store object name for complex type
FEE_SCHEDULE_LINE NUMBER 20 Yes This column is used to indicate fee schedule line Active
MAPPING_TYPE VARCHAR2 10 Yes This column is used to indicate mapping type Active
FIELD_NUM NUMBER 20 Yes This column is used to indicate field num Active
SOURCE_FIELDNAME VARCHAR2 50 This column is used to indicate source fieldname Active
SOURCE_FIELDTYPE VARCHAR2 30 This column is used to indicate source fieldtype Active
SOURCE_LABEL VARCHAR2 200 This column is used to indicate source label Active
TARGET_FIELDNAME VARCHAR2 50 This column is used to indicate target fieldname Active
TARGET_LABEL VARCHAR2 200 This column is used to indicate target label Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
AGENCY_ID NUMBER 8 Yes This column is used to indicate agency id Active
LAYOUT_VERSION VARCHAR2 30 Yes LAYOUT_VERSION
TARGET_RESOURCE_NAME VARCHAR2 200 This column is used to indicate to which parent object the mapped Target Attribute belongs.
APP_SOURCE VARCHAR2 30 This column is used to indicate app source to which mapping belongs to.

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_LNP_FEE_LINE_MAP psc_lnp_record_type_b RECORD_TYPE_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_LNP_FEE_LINE_MAP_FK1 Non Unique Default RECORD_TYPE_ID Active
PSC_LNP_FEE_LINE_MAP_PK Unique Default AGENCY_ID, RECORD_TYPE_ID, FEE_SCHEDULE_ID, FEE_SCHEDULE_LINE, MAPPING_TYPE, FIELD_NUM, LAYOUT_VERSION, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE Active