| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
ROWSECCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
The class used to determine row level security
|
| 5 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 6 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 7 |
GB_EFFDT |
Date(10) |
DATE |
Group As Of Date
|
| 8 |
GB_REFINE_DATE |
Date(10) |
DATE |
Refinement Date
|
| 9 |
GPNL_BLD_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Rebuild Group
|
| 10 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 11 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 12 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 13 |
END_DT |
Date(10) |
DATE |
end date
|
| 14 |
DATE_FROM |
Date(10) |
DATE |
Date From
|
| 15 |
GPNL_MRG_TAXID |
Character(1) |
VARCHAR2(1) NOT NULL |
All companies same Tax Number
|
| 16 |
GPNL_COLUMN_3M |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employer Tax Report 3m
Tax Reduction R&D, reduction for Research & Development (S&O - Speur- en Ontwikkelwerk)
|
| 17 |
GPNL_COLUMN_4B |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Employer Tax Report 4b
|
| 18 |
RTO_MTHD |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Retroactive Method
C=Corrective
F=Forwarding
|
| 19 |
IF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
If flag
|
| 20 |
SQL_STMT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
An internal work field that contains SQL text that is to be utilized in treasury application p
|
| 21 |
GPNL_MEDIUM_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
Medium Code
11=Tape
12=Cartridge 3480
13=Cartridge 3490
14=Cartridge 3490E
15=Cartridge DAT
16=Cartridge EXABYTE
42=Diskette 3 1/2 DS
43=Diskette 3 1/2 DSHD
60=CD-ROM
|
| 22 |
GPNL_DENSITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Density
2=Diskette/CD-ROM
3=1600 bpi
4=6250 bpi
5=38 kbpi
6=76 kbpi
7=4 mm DAT
8=8 mm EXABYTE
|
| 23 |
GPNL_FILE_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
File Name
|
| 24 |
GPNL_FILE_PATH |
Character(250) |
VARCHAR2(250) NOT NULL |
File Path
|
| 25 |
GPNL_PCT_13TH_ACM |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
13th Month Allowance Percentage
|
| 26 |
GPNL_PCT_HOLID_ACM |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Holiday Allowance Percentage
|
| 27 |
GPNL_PIN_AC1_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.
|
| 28 |
GPNL_PIN_AC2_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field will be used to store the pin number of accumulator 1. This accumulator is used for on-line and hard-copy payslips.
|
| 29 |
GPNL_RPT_FILTER1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Filter by
1=EmplID
2=Group
3=Social Security Nr.
Default Value: 1
|
| 30 |
GPNL_RPT_FILTER2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Filter by 2
1=EmplID
2=Group
|
| 31 |
GPNL_SOC_NUM |
Character(20) |
VARCHAR2(20) NOT NULL |
Social Security Number
|
| 32 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 33 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
| 34 |
GPNL_CAL_PRD_ID2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID 2
|
| 35 |
GPNL_Y_N |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used in reporting
N=N
Y=Y
|
| 36 |
GPNL_RPT_FILTER4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Global payroll Report Filter 4
1=None - All Companies
2=Company
3=Establishment
4=Group ID
|
| 37 |
GP_ELN_SET |
Character(15) |
VARCHAR2(15) NOT NULL |
Element Set
|
| 38 |
GPNL_CAL_PRD_CURR |
Character(10) |
VARCHAR2(10) NOT NULL |
Current Calendar Period ID - first calendar period id
|
| 39 |
EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID (first for a range)
|
| 40 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID To
|
| 41 |
GPNL_WD_MSG_ID |
Character(32) |
VARCHAR2(32) NOT NULL |
WALVIS
Prompt Table:
GPNL_MSG_XML
|
| 42 |
EMPLR_TAX_NUM_NLD |
Number(9,0) |
DECIMAL(9) NOT NULL |
Federal Employer Tax ID
|
| 43 |
GPNL_TAX_NUM_SUF |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Number Suffix
|
| 44 |
GPNL_WD_IDENT |
Character(12) |
VARCHAR2(12) NOT NULL |
A unique identifier for an employment used within the Wage Declaration
|
| 45 |
CONTACT_TITLE |
Character(35) |
VARCHAR2(35) NOT NULL |
Contact Title
|
| 46 |
GPNL_DESCR10 |
Character(10) |
VARCHAR2(10) NOT NULL |
A 10 digit field used for a Dutch phone number
|
| 47 |
GPNL_EMPLR_TAX_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Unique ID for the Employer assigned within the Wage Declaration, composed out of the Employer Tax Number + Suffix (e.g. "L01")
|
| 48 |
GPNL_WD_MSG_NBR |
Number(7,0) |
INTEGER NOT NULL |
Message number used for the sequencing of Wage Declarations
|
| 49 |
DESCR200 |
Character(254) |
VARCHAR2(254) NOT NULL |
Long Description
|
| 50 |
GPNL_WD_PER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Wage Tax Declaration.
Period Indicator.
A=Annual
C=Period Correction
I=Initial Period
|
| 51 |
GPNL_WD_MSG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Wage tax declaration Message Indicator.
A=Adjustment Message
C=Complete Message
N=Annual
R=Correction Previous Year
X=Complete Message w/o Retro
Default Value: C
|
| 52 |
GPNL_WD_ORIG_MSG |
Character(32) |
VARCHAR2(32) NOT NULL |
Reference to the original message id, used for corrections.
|
| 53 |
GPNL_WD_PER_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Decklaration.
Totals of the WAO/WW/ZFW + Withholded Wage Tax (acc. Period based on calendar period)
|
| 54 |
GPNL_WD_TOT_AMT |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Wage Tax Declaration:
Total of WAO/WW/ZFW + Withholded Wage Tax + or - the correction of previous periods (acc. Period based on calendar period)
|
| 55 |
GPNL_WD_DELTA |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Field used in the XML structure for the Wage Declaration to store the Delta between the re-calculated and the original collective total amount to be paid for a previous period
|
| 56 |
GPNL_DESCR_10 |
Character(10) |
VARCHAR2(10) NOT NULL |
Description field of length 10
|
| 57 |
GPNL_WD_APPL |
Character(35) |
VARCHAR2(35) NOT NULL |
Wage Tax Declaration Application Name.
|
| 58 |
GPNL_WD_REL_NR |
Character(8) |
VARCHAR2(8) NOT NULL |
Unique Relation Number
|
| 59 |
GPNL_WD_SW_IN_USE |
Character(27) |
VARCHAR2(27) NOT NULL |
Software in use
|
| 60 |
GPNL_MSG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
The status of a Wage Declaration message
A=Annual
F=Finalized (Sent)
P=Pending
|
| 61 |
GPNL_YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Character field to represent a year
|
| 62 |
GPNL_HIGH_WAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indication for High Wage calculation
Y/N Table Edit
|
| 63 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|