HR_ACTN_DTL_LNG(SQL Table) |
Index Back |
|---|---|
Assignment ActnList Item CodesRelated language table for EMPL_ACTLST_NLD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  HR_ACTNLST_ITEM_CD |
Character(6) | VARCHAR2(6) NOT NULL | Action List Item Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | ACTLST_PARTICIPANT |
Character(3) | VARCHAR2(3) NOT NULL |
Ction List Participant Used by Action Item List to notify participants.
ABS=Absence Administrator ARB=Health Service Provider CMG=Case Manager EE=Employee HR=HR Administrator MGR=Manager SUP=Supervisor |
| 4 | PTAFUSER_LIST_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the approval process.
Prompt Table: PTAFUSER_LIST |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCRLONG | Long Character | CLOB | Long Description |