PI_PIFLD_TAO(SQL Table) |
Index Back |
|---|---|
PYI Field Definition TablePayroll Interface Field Definition Table |
| # | 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 | PI_FIELD_ID | Character(6) | VARCHAR2(6) NOT NULL | Payroll Interface Field ID |
| 3 | EFFDT | Date(10) | DATE |
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 |