| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PI_SYSTEM_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Payroll Interface System ID
Prompt Table:
PI_SYSTEM_TBL
|
| 2 |
PI_FIELD_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Payroll Interface Field ID
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
|
| 7 |
PI_FIELD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
HRAJHK -- Removed Translate value 'E' as part of Target Effective Date as a Key Section of Detail Design
C=Character
D=Date
N=Number
S=Signed Number
V=Value
Default Value: C
|
| 8 |
EXT_FLDID_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
External Field ID
|
| 9 |
EXT_COL_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
External Column Name
|
| 10 |
PI_TEXT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Types
A=Pay Frequency
B=Pay Period Begin Date
C=Constant
D=Compare Date
E=Export Date
F=PI Config ID
G=Termination Count
H=Hire Count
I=External Record Code
J=Paygroup Country Code
K=Paygroup Currency Code
L=Logical Record Count
M=Processing Company
N=Interface Run Number
O=Process Option
P=Pay End Date
Q=Check Date
R=Pay Run ID
S=System ID
T=Compare Time
U=Processing Paygroup
X=Export Time
Y=Physical Record Count
|
| 11 |
PI_PROCESS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Type
B=Export/Import
E=Export
I=Import
Default Value: E
|
| 12 |
PI_FIELD_LEN |
Number(3,0) |
SMALLINT NOT NULL |
Payroll Interface Field Length
|
| 13 |
DECIMAL_LEN |
Number(2,0) |
SMALLINT NOT NULL |
Payroll Interface Decimal Len
|
| 14 |
DISPLAY_DEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Interface Dispaly Dec?
Y/N Table Edit
Default Value: N
|
| 15 |
ROUND_DEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Rounding Decimal
N=No Rounding
S=Standard Rounding Rules
T=Truncate Decimals
U=Round to Next Whole Number
|
| 16 |
DECIMAL_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Decimal Character
|
| 17 |
SIGN_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Position
L=Leading
T=Trailing
U=Unsigned Numeric
|
| 18 |
SIGN_POS_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Positive Sign
Y/N Table Edit
Default Value: N
|
| 19 |
SIGN_POS_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Positive Character
|
| 20 |
SIGN_NEG_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Negative Character
|
| 21 |
DT_FORMAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Format
A=MM/DD/YY
B=MM/DD/YYYY
C=MMDDYY
D=MMDDYYYY
E=YY/MM/DD
F=YYYY/MM/DD
G=YYMMDD
H=YYYYMMDD
I=DD/MM/YY
J=DD/MM/YYYY
K=DDMMYY
L=DDMMYYYY
M=YYYY-MM-DD
N=YYYY
O=YY
P=MM/DD
Q=MMDD
R=MM
S=DD/MM
T=DDMM
U=DD
V=CC
|
| 22 |
JUSTIFICATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Justification
L=Left
R=Right
Default Value: L
|
| 23 |
PAD_FIELD_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Pad Field Indicator
Y/N Table Edit
|
| 24 |
PAD_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Pad Character
|
| 25 |
PS_RECORD_NM |
Character(15) |
VARCHAR2(15) NOT NULL |
PeopleSoft Record Name
Prompt Table:
PI_PS_REC_VW
|
| 26 |
PS_FIELD1_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
PeopleSoft Field1 Name
Prompt Table:
PI_RECFLD_VW
|
| 27 |
PS_FIELD2_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Peoplesoft Field2 Name
Prompt Table:
PI_RECFLD_VW
|
| 28 |
PS_FIELD3_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Peoplesoft Field3 Name
Prompt Table:
PI_RECFLD_VW
|
| 29 |
PI_PROCESS_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
PI Process ID
Prompt Table:
PI_PROCESS_VW
|
| 30 |
PI_INSTANCE_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
Instance ID
Prompt Table:
PI_INSTANCE_TBL
|
| 31 |
PI_XLAT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
PI Translate Indicator
A=Translate All
D=Translate or Use Default Value
N=No Translate Values
P=Translate or Use PS Value
Default Value: N
|
| 32 |
PI_DFLT_VALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Payroll Interface Default Val
|
| 33 |
BLANK_IF_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
Blank If Zero
Y/N Table Edit
Default Value: N
|
| 34 |
REMOVE_TRAIL_SPACE |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove Trailing Spaces
Y/N Table Edit
Default Value: PI_SYSTEM_TBL.REMOVE_TRAIL_SPACE
|
| 35 |
NULL_BLANK_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Null Blank Character Flds
Y/N Table Edit
Default Value: PI_SYSTEM_TBL.NULL_BLANK_CHAR
|
| 36 |
NULL_ZERO_NUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Null Zero Numeric Flds
Y/N Table Edit
Default Value: PI_SYSTEM_TBL.NULL_ZERO_NUM
|