APC_EXTENSION



Column Section Top of Page


Table-level Detail

Description: APC Extension
Definition: Contains APC vocabulary specific data.
Table Type: REFERENCE





Column Detail - APC_EXTENSION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
APC_EXTENSION_ID DOUBLE N Primary key for the table. Uniquely identifies a row within the table.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTRIBUTOR_SOURCE_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
MINIMUM_UNADJ_COINS DOUBLE Y Minimum Unadjusted CoinsuranceColumn
NATIONAL_UNADJ_COINS DOUBLE Y National Unadjusted CoinsuranceColumn
PAYMENT_RATE DOUBLE Y Payment RateColumn
RELATIVE_WEIGHT DOUBLE Y Relative WeightColumn
SOURCE_IDENTIFIER VARCHAR(50) N Unique code within the APC vocabulary.
STATUS_INDICATOR CHAR(1) Y Status IndicatorColumn
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.


CMT_CODE_VALUE_ALIAS_LOAD



Column Section Top of Page


Table-level Detail

Description: CMT_CODE_VALUE_ALIAS_LOAD
Definition: Used only to load CMT data to the CODE_VALUE_ALIAS table.
Table Type: REFERENCE





Column Detail - CMT_CODE_VALUE_ALIAS_LOAD


Column Name Type Null? Definition
ALIAS VARCHAR(255) N Loads ALIAS on CODE_VALUE_ALIAS.
ALIAS_TYPE_MEANING VARCHAR(12) N Loads ALIAS_TYPE_MEANING on CODE_VALUE_ALIAS.
CODE_SET DOUBLE N Loads CODE_SET on CODE_VALUE_ALIAS.
CODE_VALUE_UUID VARCHAR(100) N Loads CODE_VALUE_UUID on CODE_VALUE_ALIAS.
CONTRIBUTOR_SOURCE_MEAN VARCHAR(12) N Loads CONTRIBUTOR_SOURCE_MEAN on CODE_VALUE_ALIAS.
PRIMARY_IND DOUBLE N Loads PRIMARY_IND on CODE_VALUE_ALIAS.
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.


CMT_CODE_VALUE_EXT_LOAD



Column Section Top of Page


Table-level Detail

Description: Used only to load CMT data to the CODE_VALUE_ALIAS table.
Definition: Used only to load CMT data to the CODE_VALUE_EXTENSION table.
Table Type: REFERENCE





Column Detail - CMT_CODE_VALUE_EXT_LOAD


Column Name Type Null? Definition
CODE_SET DOUBLE N Loads CODE_SET on CODE_VALUE_EXTENSION.
CODE_VALUE_UUID VARCHAR(100) N Loads CODE_VALUE_GUID on CODE_VALUE_EXTENSION.
FIELD_NAME VARCHAR(32) N Loads FIELD_NAME on CODE_VALUE_EXTENSION.
FIELD_TYPE DOUBLE N Loads FIELD_TYPE on CODE_VALUE_EXTENSION.
FIELD_VALUE VARCHAR(100) N Loads FIELD_VALUE on CODE_VALUE_EXTENSION.
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.


CMT_CODE_VALUE_LOAD



Column Section Relationship Section Top of Page


Table-level Detail

Description: CMT_CODE_VALUE_LOAD
Definition: Used only to load CMT data to the CODE_VALUE table.
Table Type: REFERENCE





Column Detail - CMT_CODE_VALUE_LOAD


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CDF_MEANING VARCHAR(12) N Loads CDF_MEANING on CODE_VALUE.
CKI VARCHAR(100) N Loads CKI on CODE_VALUE.
CODE_SET DOUBLE N Loads CODE_SET on CODE_VALUE.
CODE_VALUE DOUBLE N Maps CODE_VALUE from the CODE_VALUE table to a CMT code value
CODE_VALUE_UUID VARCHAR(100) N Loads CODE_VALUE_UUID on CODE_VALUE.
COLLATION_SEQ DOUBLE N Loads COLLATION_SEQ on CODE_VALUE.
CONCEPT_CKI VARCHAR(100) N Loads CONCEPT_CKI on CODE_VALUE.
DEFINITION VARCHAR(100) N Loads DEFINITION on CODE_VALUE.
DESCRIPTION VARCHAR(60) N Loads DESCRIPTION on CODE_VALUE.
DISPLAY VARCHAR(40) N Loads DISPLAY on CODE_VALUE.
DISPLAY_KEY VARCHAR(40) N Loads DISPLAY_KEY on CODE_VALUE.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
IGNORE_IND DOUBLE N Indicates whether to ignore the row inthe Bedrock Wizard
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 - CMT_CODE_VALUE_LOAD


Child Column in CMT_CODE_VALUE_LOAD(FK) Parent Table Name Parent Column Name
Parents: CODE_VALUE CODE_VALUE CODE_VALUE


CMT_CODE_VALUE_OUTBND_LOAD



Column Section Top of Page


Table-level Detail

Description: CMT_CODE_VALUE_OUTBND_LOAD
Definition: Used only to load CMT data to the CODE_VALUE_OUTBOUND table.
Table Type: REFERENCE





Column Detail - CMT_CODE_VALUE_OUTBND_LOAD


Column Name Type Null? Definition
ALIAS VARCHAR(255) N Loads ALIAS on CODE_VALUE_OUTBOUND.
ALIAS_TYPE_MEANING VARCHAR(12) N Loads ALIAS_TYPE_MEANING on CODE_VALUE_OUTBOUND.
CODE_SET DOUBLE N Loads CODE_SET on CODE_VALUE_OUTBOUND.
CODE_VALUE_UUID VARCHAR(100) N Loads CODE_VALUE_UUID on CODE_VALUE_OUTBOUND.
CONTRIBUTOR_SOURCE_MEAN VARCHAR(12) N Loads CONTRIBUTOR_SOURCE_MEAN on CODE_VALUE_OUTBOUND.
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.