| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PI_SYSTEM_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Payroll Interface System ID
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 6 |
PI_VERSION |
Character(10) |
VARCHAR2(10) NOT NULL |
Interface Payroll System Ver
|
| 7 |
SYSTEM_ID_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
System Code
A=ADP Interface
O=Other
|
| 8 |
CONVERT_EMPLID |
Character(1) |
VARCHAR2(1) NOT NULL |
Convert Emplid
C=Using Interface Employee Table
N=Using Peoplesoft Employee ID
S=Using National ID
Default Value: N
|
| 9 |
PI_FILE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Interface File Type
C=Comma Separated (CSV)
L=Logical
O=Other Delimited
P=Physical
T=Tab Delimited
Default Value: P
|
| 10 |
EXPORT_CHG_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Change Indicator
F=Field Changes Only
R=Records with Field Changes
Default Value: R
|
| 11 |
EXT_FLDID_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
External Field ID Indicator
Y/N Table Edit
Default Value: N
|
| 12 |
EXT_FLDID_LEN |
Number(2,0) |
SMALLINT NOT NULL |
External Field ID Length
|
| 13 |
EXP_HIST_MTH |
Number(2,0) |
SMALLINT NOT NULL |
Export History
|
| 14 |
PI_EMPLID_FIELD |
Character(6) |
VARCHAR2(6) NOT NULL |
PI Employee Field
|
| 15 |
CONVERT_CASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Convert Case
Y/N Table Edit
Default Value: N
|
| 16 |
EFFDT_TRANS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Effect Date Transaction Ind
N=Current
R=All
Default Value: N
|
| 17 |
DATA_DELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Delimiter
|
| 18 |
LITERAL_STRING_CHR |
Character(1) |
VARCHAR2(1) NOT NULL |
Literal String Character
|
| 19 |
LAST_FLD_DELIMITER |
Character(1) |
VARCHAR2(1) NOT NULL |
End Last Field with Delimiter
Y/N Table Edit
Default Value: Y
|
| 20 |
INCL_HEADER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Header
Y/N Table Edit
Default Value: N
|
| 21 |
REMOVE_TRAIL_SPACE |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove Trailing Spaces
Y/N Table Edit
Default Value: Y
|
| 22 |
NULL_BLANK_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Null Blank Character Flds
Y/N Table Edit
Default Value: Y
|
| 23 |
NULL_ZERO_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Null Zero Numeric Flds
Y/N Table Edit
Default Value: Y
|
| 24 |
PI_PROCESS_FILTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Filter Type
C=Company Filtering
N=No Filtering
Default Value: N
|
| 25 |
CHARSET |
Character(40) |
VARCHAR2(40) NOT NULL |
Character Set
Default Value: ASCII
Prompt Table:
CHARSET_VW
|
| 26 |
PI_EXPT_DEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Export Destination
F=External File
T=Table
Default Value: F
|