HR_ACTNLST_ITEM_CDEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
D=Day
W=Week
Default Value: W
HR_ACTN_DEF_NLD(SQL Table) |
Index Back |
|---|---|
Assignment ActList Item CodesUse HR_ACTN_LST_NLD and HR_ACTN_DEF_NLD to maintain any type of NLD actionList needed by your company. HR_ACTN_LST_NLD contains the code assigned to the actionList and a description of the actionList HR_ACTN_DEF_NLD contains the specific items on the actionList. For example, if your company has employees on overseas assignments, you might have a checklist for expatriate processing and another for repatriation. The expatriate checklist might contain items such as briefing, school applications for dependents, physical exams, obtain work permits, and obtain passports and visas. |
| # | 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 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type CD
N=Customer Data S=Sample Data Y=System Data Default Value: N |
| 7 | PERIOD_DAYS | Signed Number(6,0) | DECIMAL(5) NOT NULL | Period/Duration Days |
| 8 | MIN_NOTIFY_DAYS | Number(3,0) | SMALLINT NOT NULL | Minimum Notification Days |
| 9 | HR_ACTN_FREQ_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Follow-up Action NLD
The duration can be determined in Days or Weeks
D=Day W=Week Default Value: W |
| 10 | TOTAL_GOAL | Number(7,0) | INTEGER NOT NULL | Total Goal |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |