PYCYCL_MAP_SQL (SQL Table)	Index Back
Payment mapping header

PYCYCL_MAP_SQL

(SQL Table)

Payment mapping header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
Default Value: PYCYCL_MAP_HDR.SOURCE_TXN
Prompt Table: PYMNT_SOURCE

2 MAP_TYPE Character(2) VARCHAR2(2) NOT NULL Map Type
D1=Pay Cycle Data
D2=Payment Data (Child)
V1=Prenote Data
W1=Withholding Data
W2=Withholding Data (Child)
Default Value: PYCYCL_MAP_HDR.MAP_TYPE

3 PYCYCL_SQL_TYPE Character(1) VARCHAR2(1) NOT NULL Pay Cycle SQL Statement Type
A=Select SQL
B=Delete SQL
C=Insert Temp SQL
D=Delete Temp SQL
E=Update SQL
F=Select Where

4 PYCYCL_SQL_STMT Long Character CLOB Pay Cycle SQL Statement

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOURCE_TXN	Character(4)	VARCHAR2(4) NOT NULL	Source Transaction Default Value: PYCYCL_MAP_HDR.SOURCE_TXN Prompt Table: PYMNT_SOURCE
2	MAP_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Map Type D1=Pay Cycle Data D2=Payment Data (Child) V1=Prenote Data W1=Withholding Data W2=Withholding Data (Child) Default Value: PYCYCL_MAP_HDR.MAP_TYPE
3	PYCYCL_SQL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Pay Cycle SQL Statement Type A=Select SQL B=Delete SQL C=Insert Temp SQL D=Delete Temp SQL E=Update SQL F=Select Where
4	PYCYCL_SQL_STMT	Long Character	CLOB	Pay Cycle SQL Statement