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