Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
COMPANY_ID |
|
VARCHAR(10) |
NO |
Name: Record Key. Description: The company ID for the configuration labels. |
COUNTRY_CD |
|
VARCHAR(2) |
NO |
Name: Country. Description: The country code for the configuration labels. |
LANGUAGE_CD |
|
VARCHAR(2) |
NO |
Name: Language. Description: The language code for the configuration labels. |
EMPL_CODE1_LBL |
|
VARCHAR(20) |
YES |
Name: Employee User Defined Code Label 1. Description: Label for the first user-defined alphanumeric field in the employee table. |
EMPL_CODE2_LBL |
|
VARCHAR(20) |
YES |
Name: Employee User Defined Code Label 2. Description: Label for the second user-defined alphanumeric field in the employee table. |
EMPL_CODE3_LBL |
|
VARCHAR(20) |
YES |
Name: Employee User Defined Code Label 3. Description: Label for the third user-defined alphanumeric field in the employee table. |
EMPL_DATE1_LBL |
|
VARCHAR(20) |
YES |
Name: Employee User Defined Date Label 1. Description: Label for the first user-defined date field in the employee table. |
EMPL_DATE2_LBL |
|
VARCHAR(20) |
YES |
Name: Employee User Defined Date Label 2. Description: Label for the second user-defined date field in the employee table. |
EMPL_DATE3_LBL |
|
VARCHAR(20) |
YES |
Name: Employee User Defined Date Label 3. Description: Label for the third user-defined date field in the employee table. |
UDT01_CODE1_LBL |
|
VARCHAR(20) |
YES |
Name: UDT01 User Defined Code Label 1. Description: Label for the first user-defined alphanumeric field in the UDT01 table. |
UDT01_CODE2_LBL |
|
VARCHAR(20) |
YES |
Name: UDT01 User Defined Code Label 2. Description: Label for the second user-defined alphanumeric field in the UDT01 table. |
UDT01_CODE3_LBL |
|
VARCHAR(20) |
YES |
Name: UDT01 User Defined Code Label 3. Description: Label for the third user-defined alphanumeric field in the UDT01 table. |
UDT01_DATE1_LBL |
|
VARCHAR(20) |
YES |
Name: UDT01 User Defined Date Label 1. Description: Label for the first user-defined date field in the UDT01 table. |
UDT01_DATE2_LBL |
|
VARCHAR(20) |
YES |
Name: UDT01 User Defined Date Label 2. Description: Label for the second user-defined date field in the UDT01 table. |
UDT01_DATE3_LBL |
|
VARCHAR(20) |
YES |
Name: UDT01 User Defined Date Label 3. Description: Label for the third user-defined date field in the UDT01 table. |
UDT02_CODE1_LBL |
|
VARCHAR(20) |
YES |
Name: UDT02 User Defined Code Label 1. Description: Label for the first user-defined alphanumeric field in the UDT02 table. |
UDT02_CODE2_LBL |
|
VARCHAR(20) |
YES |
Name: UDT02 User Defined Code Label 2. Description: Label for the second user-defined alphanumeric field in the UDT02 table. |
UDT02_CODE3_LBL |
|
VARCHAR(20) |
YES |
Name: UDT02 User Defined Code Label 3. Description: Label for the third user-defined alphanumeric field in the UDT02 table. |
UDT02_DATE1_LBL |
|
VARCHAR(20) |
YES |
Name: UDT02 User Defined Date Label 1. Description: Label for the first user-defined date field in the UDT02 table. |
UDT02_DATE2_LBL |
|
VARCHAR(20) |
YES |
Name: UDT02 User Defined Date Label 2. Description: Label for the second user-defined date field in the UDT02 table. |
UDT02_DATE3_LBL |
|
VARCHAR(20) |
YES |
Name: UDT02 User Defined Date Label 3. Description: Label for the third user-defined date field in the UDT02 table. |
MODIFIED_BY |
|
VARCHAR(20) |
NO |
Name: Modified By. Description: The User ID of the person who last modified this record. |
ROWVERSION |
|
NUMERIC(10, 0) |
NO |
Name: Row Version. Description: The number of times this record has been updated. |
TIME_STAMP |
|
DATE |
NO |
Name: Time Stamp. Description: Date and time the record was last modified. |
PROVIDER_CODE1_LBL |
|
VARCHAR(20) |
YES |
Name: Provider User Defined Code 1 Label. Description: Label for the first user-defined alphanumeric field in the provider table. |
PROVIDER_CODE2_LBL |
|
VARCHAR(20) |
YES |
Name: Provider User Defined Code 2 Label. Description: Label for the second user-defined alphanumeric field in the provider table. |
PROVIDER_CODE3_LBL |
|
VARCHAR(20) |
YES |
Name: Provider User Defined Code 3 Label. Description: Label for the third user-defined alphanumeric field in the provider table. |
SECURITY_QUESTION_S |
|
VARCHAR(4000) |
YES |
Name: . Description: Security Question. |