| # |
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 |
XML_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
XML Set
|
| 4 |
XML_TEMPLATE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Template type
Prompt Table:
XML_TEMPLT_TBL
|
| 5 |
XMLFILE_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
XML File ID
|
| 6 |
SOCS_AUTH_KEY_ESP |
Character(8) |
VARCHAR2(8) NOT NULL |
Authorization Key
Prompt Table:
SOCS_SETHD_VW
|
| 7 |
GPES_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year
|
| 8 |
GPES_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Month
|
| 9 |
GPES_SSTC_PYMT_OPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Type. This field is used to generate the FAN File.
L00=Regular
L02=Litigation Salary
L03=Retroactivity wo/Surcharge
L09=Retroactivity w/Surcharge
L13=Vacations (L13)
L31=Regular and Vacations (L13)
L99=Full
|
| 10 |
GPES_REUSE_PRV_BS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reuse Previous Month Bases for Creta reporting
Y/N Table Edit
|
| 11 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 12 |
GPES_MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 13 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 14 |
GPES_FILE_PATH |
Character(250) |
VARCHAR2(250) NOT NULL |
Output / Input file path
|
| 15 |
GPES_FILE_NAME |
Character(250) |
VARCHAR2(250) NOT NULL |
Name of a file, according to the process scheduler server.
|
| 16 |
GPES_CRT_STAT_NR |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Box to select No Reported employees for Creta reporting
Y/N Table Edit
|
| 17 |
GPES_CRT_STAT_WE |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Box to select With Errors employees for Creta reporting
Y/N Table Edit
|
| 18 |
GPES_CRT_STAT_SM |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Box to select Manually Selected employees for Creta reporting
Y/N Table Edit
|
| 19 |
GPES_CRT_STAT_AL |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Box to select All employees for Creta reporting
Y/N Table Edit
|
| 20 |
GPES_CRT_STATUS_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
CRET@ Employee reporting status
0=No Reported
1=Reported
E=With Errors
M=Manually Selected
V=Validated
X=Excluded
|
| 21 |
GPES_CRT_RECTIFCTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Data for Creta reporting
Y/N Table Edit
|
| 22 |
GPES_CRT_RECTF_OOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Out of Date Rectification flag
Y/N Table Edit
Default Value: N
|
| 23 |
GPES_CRT_NEG_BASES |
Character(1) |
VARCHAR2(1) NOT NULL |
Negative Bases Management for Creta reporting:
F - Exclude Full Employee
B - Exclude Only Negative Bases.
M - Exclude Month Slice
B=Exclude Slice with Negative
F=Exclude Full Employee
M=Exclude Month with Negative
R=Exclude only Negative Bases
Default Value: B
|
| 24 |
GPES_CRT_CALC_DTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee calculation data break down
Y/N Table Edit
Default Value: N
|
| 25 |
GPES_MONTH_PMNT |
Number(2,0) |
SMALLINT NOT NULL |
Month in which an earning is paid.
|
| 26 |
GPES_YEAR_PMNT |
Number(4,0) |
SMALLINT NOT NULL |
Year in which an earning is paid.
|
| 27 |
GPES_CRT_DOC_TMPLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Liquidation Doc Template Type
- D Request of a Draft
- B XML of Bases
- R Response XML
- S Slices XML
- C Calculations XML
- X Request of Slices
- Y Request of Calculation
- Z Request of Confirmation
B=XML of Bases
C=Calculation Details
D=Request of a Draft
R=Response
S=Employees Slices
X=Request of Slices
Y=Request of Calculations
Z=Request of Confirmation
|
| 28 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 29 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|