| # |
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 |
GPAU_TAX_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Tax Year - End of Year Processing
|
| 4 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table:
GP_PYENT_SGPAU
|
| 5 |
GPAU_STP_FILETYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
File Type determines the Type of STP File Generation
P=Pay Event
U=Update Event
Default Value: P
|
| 6 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
GPAU_CALGRP_VW
|
| 7 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
Prompt Table:
GPAU_PYMT_DT_VW
|
| 8 |
GPAU_TAX_YR_BGN_DT |
Date(10) |
DATE |
Begin Date
|
| 9 |
GPAU_TAX_YR_END_DT |
Date(10) |
DATE |
End Date
|
| 10 |
GPAU_STP_PRCS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Header - STP File Generation Process
Y/N Table Edit
Default Value: N
|
| 11 |
GPAU_RUN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Run Type for EOY Magnetic Type
10=Production
20=Test
Default Value: 20
|
| 12 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GPAU_PYGRP_VW
|
| 13 |
GPAU_STP_DECLARE |
Character(1) |
VARCHAR2(1) NOT NULL |
Declaration for Reporting Party - Single Touch Payroll
N=False
Y=True
Default Value: Y
|
| 14 |
GPAU_STP_REP_PARTY |
Character(1) |
VARCHAR2(1) NOT NULL |
Reporting Party of STP - Payer or Intermediary
E=Payer/Employer
I=Intermediary
Default Value: E
|
| 15 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 16 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 17 |
GPAU_FILE_REPLACE |
Character(1) |
VARCHAR2(1) NOT NULL |
Full File Replacement Indicator - Single Touch Payroll
Y/N Table Edit
Default Value: N
|
| 18 |
GPAU_STP_TRANS_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Submission ID - Single Touch Payroll
Prompt Table:
GPAU_TRANSID_VW
|
| 19 |
GPAU_PREV_BMS_ID |
Character(200) |
VARCHAR2(200) NOT NULL |
Previous Business Management System Identifier - Single Touch Payroll.
|
| 20 |
GPAU_STP_FINAL_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Event Indicator - Single Touch Payroll
A=All Payees
N=Not Applicable
T=Terminated Payees
Y=Active Payees
Default Value: N
|
| 21 |
GPAU_STP_FIRST_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
First Payroll Event - Single Touch Payroll
Y/N Table Edit
Default Value: N
|
| 22 |
GPAU_STP_UPDEVT_DT |
Date(10) |
DATE |
Update Event Date
Prompt Table:
GPAU_UPD_DT_VW
|
| 23 |
XML_ROOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Root node
Y/N Table Edit
|
| 24 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 25 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 26 |
GPAU_ACKNOWLEDGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Acknowledge Field for GPAU STP File Generation Run control.
Y/N Table Edit
Default Value: N
|
| 27 |
GPAU_RUNDTTM |
DateTime(26) |
TIMESTAMP |
Field to capture Run DateTime
Default Value: %datetime
|
| 28 |
DESCRLONG |
Long Character |
CLOB |
Long Description
|
| 29 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
Prompt Table:
GPAU_PRDEND_DVW
|
| 30 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table:
GPAU_CALPRD_DVW
|
| 31 |
GPAU_PYMT_DT |
Date(10) |
DATE |
Payment Date
Prompt Table:
GPAU_PYMTDT_DVW
|
| 32 |
GPAU_STP_PRC_CLGRP |
Character(1) |
VARCHAR2(1) NOT NULL |
Processed Calender Groups - Single Touch Payroll
|
| 33 |
SELECT_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Select All
|
| 34 |
DESELECT_ALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Deselect All
|