EMPL_ACTITM_LNG(SQL Table) |
Index Back |
|---|---|
EE Assignment Checklist ItemsEMPL_ACTITM_LNG related language table voor table: EMPL_ACTITM_NLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Default Value: 0 Prompt Table: PER_ORG_ASGN_VW |
| 3 | HR_ACTION_LIST_DT |
Date(10) | DATE NOT NULL |
Action List Date
Default Value: %date Prompt Table: EMPL_CHECKLIST |
| 4 | HR_ACTION_LIST_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Action List
Prompt Table: HR_ACTN_LST_NLD |
| 5 | ACTION_DT |
Date(10) | DATE NOT NULL |
Action Date
Default Value: %date |
| 6 | HR_ACTNLST_ITEM_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Action List Item Code
Prompt Table: HR_ACTN_DEF_NLD |
| 7 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 8 | DESCRLONG_NOTES | Long Character | CLOB | Long Description |