Table Detail Report
PL_SEGMENT_POS_XREF
Column Section | Top of Page |
Table-level Detail
Description: | PL SEGMENT POS XREF |
Definition: | This table saves the viewable and sequenced segments by user position. |
Table Type: | REFERENCE |
Column Detail - PL_SEGMENT_POS_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
POSITION_CD | DOUBLE | N | Stores user position. Code set 88. |
SEGMENT_TYPE_CD | DOUBLE | N | Stores the segment type. Code set 2225. |
SEQUENCE | DOUBLE | N | Used to determine viewable order of selected segment types by user position. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
PL_SEG_CAT_CD_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PL SEG CAT CD XREF |
Definition: | This table stores the segment data for specific orderable items. |
Table Type: | REFERENCE |
Column Detail - PL_SEG_CAT_CD_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DATA_IND | DOUBLE | N | Indicator used to determine if the data stored in SEGMENT_DATA_ID is active. |
CATALOG_CD | DOUBLE | N | Stores the order catalog item. |
SEGMENT_DATA_ID | DOUBLE | N | Unique identifier to the LONG_BLOB table used to store segment data. |
SEGMENT_ID | DOUBLE | N | Unique identifier to the PL_CATALOG_SEGMENTS table for specific segment. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - PL_SEG_CAT_CD_XREF
Child Column in PL_SEG_CAT_CD_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
SEGMENT_ID | PL_CATALOG_SEGMENTS | SEGMENT_ID |
PL_XREF_DEFAULTS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PL XREF DEFAULTS |
Definition: | Stores client and insurance company relationships. |
Table Type: | REFERENCE |
Column Detail - PL_XREF_DEFAULTS
Column Name | Type | Null? | Definition |
---|---|---|---|
INSURANCE_ID | DOUBLE | N | Insurance id is the organaztion id that identifies an insurance carrier. |
ORGANIZATION_ID | DOUBLE | N | Represents the client ID that this insurance company is associated with. |
SEQUENCE | DOUBLE | Y | The order of the selected insurance organizations. |
UPDATED_BY_IND | DOUBLE | Y | Indicates the application that this setting applies to. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
XREF_SEQUENCE | DOUBLE | Y | Used to determine if the default row exists. |
Relationship Detail - PL_XREF_DEFAULTS
Child Column in PL_XREF_DEFAULTS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |