| # |
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 |
PI_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Interface Run Type
E=Export
I=Import
Default Value: E
|
| 4 |
RUN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Run ID
Prompt Table:
PAY_RUN_TBL
|
| 5 |
PI_RUN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
PI Run Option
N=New
P=Reprocess
R=Restart
|
| 6 |
PI_RUN_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Payroll Interface Run Number
Prompt Table:
PI_RUN_TBL
|
| 7 |
CHKPT_INTERVAL |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Chk Point Interval in Minutes
|
| 8 |
EXPORT_CHG_FULL |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Change or Full
C=Changes Only
F=Full Set of Records
Default Value: C
|
| 9 |
EXCLUDE_DEDCALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude Calculated Deductions
Y/N Table Edit
Default Value: N
|
| 10 |
ACTIVE_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Employees
Y/N Table Edit
Default Value: Y
|
| 11 |
PI_REPROCESS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
PI Reprocess Indicator
C=Compare
E=Export
I=Import
L=Load
N=None
Default Value: N
|
| 12 |
PI_SELECT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Selection Process Type
A=Manually Select
C=Smart Select
D=All Employees in Group
|
| 13 |
GVT_PI_FILE_OUTPUT |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Interface Output Files
A=All files
E=PACT file
P=PMSO file
Default Value: A
|
| 14 |
GVT_PI_PP_SEQ |
Character(2) |
VARCHAR2(2) NOT NULL |
Pay Period Sequence Number
|
| 15 |
GVT_PI_INTERFACE |
Character(1) |
VARCHAR2(1) NOT NULL |
NFC Interface
Y/N Table Edit
Default Value: N
|
| 16 |
CBL_AE_SEPARATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to determine if external file write will be done at once or if the COBOL will be run by one user and the Ap Engine will be run by another user.
Y/N Table Edit
Default Value: N
|
| 17 |
COBOL_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag is set if the COBOL has completed for the export and the Ap Engine process must be run in order to complete the export.
Y/N Table Edit
Default Value: N
|