EMPLIDPrompt Table: PERSON
EMPL_RCDDefault Value: 0
Prompt Table: PER_ORG_ASGN_VW
HR_ACTION_LIST_DTDefault Value: %date
HR_ACTION_LIST_CDPrompt Table: HR_ACTN_LST_NLD
Prompt Table: PERSON_NAME
Prompt Table: SET_VLD_HR_07
Default Value: %date
EMPL_ACTLST_NLD(SQL Table) |
Index Back |
|---|---|
EE Assignment ActionListis primarily used to create a list of tasks for an employee in the International Assignments application. However, it can also be used in Personnel Administration, Recruiting, or anywhere that a task list is a desired feature. There is one record in this table for each dated list. |
| # | 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 |
| 4 | HR_ACTION_LIST_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Action List
Prompt Table: HR_ACTN_LST_NLD |
| 5 | RESPONSIBLE_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table: PERSON_NAME |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_HR_07 |
| 7 | ABSENCE_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 8 | NOTIFIED_DT | Date(10) | DATE |
Date First Notified
Default Value: %date |
| 9 | RETURN_DT | Date(10) | DATE | Return Date |
| 10 | COMMENTS | Long Character | CLOB | Comment |