| # |
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 |
ERE_ID_ESP |
Character(10) |
VARCHAR2(10) NOT NULL |
ERE ID
Prompt Table:
ERE_DATA_ESP
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
ERE_CMP_DTA_ESP
|
| 5 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 6 |
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
Default Value: 01
|
| 7 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
SOCS_ALL_CCC_VW
|
| 8 |
XML_SET |
Character(5) |
VARCHAR2(5) NOT NULL |
XML Set
Default Value: G01
Prompt Table:
XML_SET_TBL
|
| 9 |
XML_TEMPLATE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Template type
Prompt Table:
XML_TEMPLT_TBL
|
| 10 |
ERE_SEND_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE XML Procedure Send Type
A=New Communication
V=Update Communication
|
| 11 |
ERE_PROC_TYPE_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
ERE Procedure Type
Permanent : E
Permanent and suspension : ES
Permanent, Suspension and Reduction : ESR
Suspension : S
Suspension and Reduction : SR
Reduction : R
E=Permanent
ER=Permanent/Reduction
ES=Permanent/Suspend
ESR=Permanent/Suspend/Reduction
R=Reduction
S=Suspend
SR=Suspend/Reduction
|
| 12 |
COMPNY_CITY_CD_ESP |
Character(5) |
VARCHAR2(5) NOT NULL |
City Code
Prompt Table:
CITY_CD_ESP_VW
|
| 13 |
LOCATN_CITY_CD_ESP |
Character(5) |
VARCHAR2(5) NOT NULL |
City Code
Prompt Table:
CITY_CD_ESP_VW
|
| 14 |
ERE_NBR_FRMTD_ESP |
Character(11) |
VARCHAR2(11) NOT NULL |
ERE Number (Formatted)
|
| 15 |
ERE_PRCS_FLG_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Report as XML flag
0=Not Communicated
1=XML Generated
2=XML Sent/Confirmated
Default Value: 0
|
| 16 |
ERE_EVENT_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
ERE Event Type
A : New
B : Delete
M: Update
A=New
B=Delete
M=Update
|
| 17 |
FILE_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
Input/Output file path
|
| 18 |
FILE_NAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|