| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
NL_FROM_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year from
|
| 4 |
NL_FROM_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Month from
|
| 5 |
NL_THRU_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year thru
|
| 6 |
NL_THRU_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Month thru
|
| 7 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 9 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 10 |
NL_IND_HIERARCHY |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Hierarchy
Y/N Table Edit
Default Value: N
|
| 11 |
NL_IND_LV |
Character(1) |
VARCHAR2(1) NOT NULL |
Long-term Illness
E=Excluded
I=Included
Default Value: ABS_PARAMETERS.IND_LV_NLD
|
| 12 |
NL_IND_PV |
Character(1) |
VARCHAR2(1) NOT NULL |
Partial Illness
E=Excluded
I=Included
Default Value: ABS_PARAMETERS.IND_PV_NLD
|
| 13 |
NL_IND_ZV |
Character(1) |
VARCHAR2(1) NOT NULL |
Maternity Leave
E=Excluded
I=Included
Default Value: ABS_PARAMETERS.IND_ZV_NLD
|
| 14 |
NL_INITFILE |
Character(50) |
VARCHAR2(50) NOT NULL |
Initial Postal Code Loadfile
|
| 15 |
NL_UPDATEFILE |
Character(50) |
VARCHAR2(50) NOT NULL |
Update Postal Code File
|
| 16 |
ASOFDATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 17 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 18 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 19 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 20 |
END_DT |
Date(10) |
DATE |
end date
|
| 21 |
PROCESS_DT |
Date(10) |
DATE |
Process Date
|
| 22 |
EDM_MSG_ID_NLD |
Character(32) |
VARCHAR2(32) NOT NULL |
First Hire Date Declaration.
|
| 23 |
EDM_STATUS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
First Hire Date Declaration:
Review Status.
1=All (re-)hires
2=New (re-)hires
Default Value: 2
|
| 24 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 25 |
EDM_DESCR10_NLD |
Character(10) |
VARCHAR2(10) NOT NULL |
Description field of length 10
|
| 26 |
WP_PATH |
Character(200) |
VARCHAR2(200) NOT NULL |
Path for Agreement Document
|
| 27 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 28 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table:
EMPLMT_SRCH_GBL
|
| 29 |
REPORTING_PERIOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Period
M=Monthly
Q=Quarterly
|
| 30 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor Set ID
Prompt Table:
SETID_TBL
|
| 31 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VENDOR_PROV_VW
|
| 32 |
NL_REPORT_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for Communication
A=Change Data Social Insurance
D=Death
H=Hire
I=Change Data Industrial Board
T=Termination
Default Value: H
|
| 33 |
NL_CORRECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Correction
Y/N Table Edit
Default Value: N
|
| 34 |
NL_START_END |
Character(1) |
VARCHAR2(1) NOT NULL |
Start or End Health Insurance
E=End
S=Start
Default Value: S
|
| 35 |
NL_REASON_END |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for ending Health Insur
D=Death
E=Else
M=Military Service
S=Salary Limit Reached
T=Termination
Default Value: T
|
| 36 |
NL_REASON_ELSE |
Character(30) |
VARCHAR2(30) NOT NULL |
Reason Else
|
| 37 |
NL_START_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Reason for Start
H=Hire
T=Transition
Default Value: H
|
| 38 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 39 |
NL_CONTACTPERSON |
Character(30) |
VARCHAR2(30) NOT NULL |
Contactperson
|
| 40 |
PANEL_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Panel name
|