ADP_FLDDFN_VW (SQL View)	Index Back
ADP Field Definition View This view is used by ADP Connection to update their data dictionary in case customers use the Payroll Interface to add more fields to their interface definition. Without this view, this would all be a manual process, which would be more timely and costly to the customer. The use of this view will be triggered by an option in ADP Connection. It will be part of the customer's user guide to run this process if they ever add any new fields on the PeopleSoft side.

ADP_FLDDFN_VW

(SQL View)

ADP Field Definition View

This view is used by ADP Connection to update their data dictionary in case customers use the Payroll Interface to add more fields to their interface definition. Without this view, this would all be a manual process, which would be more timely and costly to the customer. The use of this view will be triggered by an option in ADP Connection. It will be part of the customer's user guide to run this process if they ever add any new fields on the PeopleSoft side.

SELECT A.PI_FIELD_ID , A.DESCR , A.EXT_FLDID_ID , A.PI_FIELD_TYPE , A.PI_FIELD_LEN , A.DECIMAL_LEN , A.PI_TEXT_TYPE FROM PS_PI_FIELD_TBL A , PS_PI_SYSTEM_TBL B WHERE B.PI_EXPT_DEST = 'T' AND B.EFF_STATUS = 'A' AND A.EFF_STATUS = 'A' AND A.PI_SYSTEM_ID = B.PI_SYSTEM_ID AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_PI_FIELD_TBL C WHERE C.EFFDT <= %CurrentDateIn AND A.PI_SYSTEM_ID = C.PI_SYSTEM_ID AND A.PI_FIELD_ID = C.PI_FIELD_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PI_FIELD_ID Character(6) VARCHAR2(6) NOT NULL Payroll Interface Field ID
Prompt Table: PI_FIELD_TBL

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 EXT_FLDID_ID Character(10) VARCHAR2(10) NOT NULL External Field ID

4 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

5 PI_FIELD_LEN Number(3,0) SMALLINT NOT NULL Payroll Interface Field Length

6 DECIMAL_LEN Number(2,0) SMALLINT NOT NULL Payroll Interface Decimal Len

7 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PI_FIELD_ID	Character(6)	VARCHAR2(6) NOT NULL	Payroll Interface Field ID Prompt Table: PI_FIELD_TBL
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	EXT_FLDID_ID	Character(10)	VARCHAR2(10) NOT NULL	External Field ID
4	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
5	PI_FIELD_LEN	Number(3,0)	SMALLINT NOT NULL	Payroll Interface Field Length
6	DECIMAL_LEN	Number(2,0)	SMALLINT NOT NULL	Payroll Interface Decimal Len
7	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