PY_DIRDEP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID Prompt Table: PAY_RUN_TBL
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
6	PAYGROUP	Character(3)	VARCHAR2(3) NOT NULL	Pay Group Prompt Table: PAYGROUP_TBL
7	PAY_END_DT	Date(10)	DATE	Pay Period End Date Prompt Table: PAY_CALENDAR
8	CHECK_DT	Date(10)	DATE	Check date.
9	CYCLE_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Off-Cycle B=Both F=Off-Cycle O=On-Cycle Default Value: B
10	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N
11	PAGE_NUM	Number(5,0)	INTEGER NOT NULL	Page Nbr Prompt Table: PAY_PAGE
12	PAGE_NUM_THRU	Number(5,0)	INTEGER NOT NULL	Thru Page Number Prompt Table: PAY_PAGE
13	PRENOTE_DT	Date(10)	DATE	Prenote Date
14	TEXT20	Character(20)	VARCHAR2(20) NOT NULL	Text (20 Characters)
15	PY_DDP_SEP_FILES	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether a user would like to create separate files for IAT vs DDP transactions when running the DDP001.sqr to create the US Direct deposit file. Y/N Table Edit Default Value: N
16	PY_DDP_EXCL_OFFS	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether a user would like to exclude the offset records from the US Direct deposit file when running DDP001.sqr Y/N Table Edit Default Value: N
17	PY_RESET_DDP	Character(1)	VARCHAR2(1) NOT NULL	Reset direct deposit file indicator. Y/N Table Edit Default Value: N
18	PY_FILE_TAG	Character(21)	VARCHAR2(21) NOT NULL	File Tag associated with the direct deposit file.
19	PY_EE_PAYCHECK_DT	Character(1)	VARCHAR2(1) NOT NULL	Use Pay Check Date on Employee's pay check
20	PY_NEW_FILE_TAG	Character(21)	VARCHAR2(21) NOT NULL	New File Tag associated with the direct deposit file.
21	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
22	CO_BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank Code
23	PY_TRANSIT_CHDG	Number(1,0)	SMALLINT NOT NULL	Direct Deposit Check Digit
24	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
25	PPD_COUNT	Number(8,0)	INTEGER NOT NULL	Number of PPD transactions
26	IAT_COUNT	Number(8,0)	INTEGER NOT NULL	Number of IAT transactions
27	PRENOTE_COUNT	Number(8,0)	INTEGER NOT NULL	Number of Prenote transactions
28	PPD_TTL_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	PPD Total Amount
29	IAT_TTL_AMT	Number(16,2)	DECIMAL(15,2) NOT NULL	IAT Total Amount
30	FILE_DIRECTORY	Character(80)	VARCHAR2(80) NOT NULL	File Directory
31	CHARSET	Character(40)	VARCHAR2(40) NOT NULL	Character Set
32	DESCR254A	Character(254)	VARCHAR2(254) NOT NULL	Long Description
33	PY_DD_ERRCD	Character(3)	VARCHAR2(3) NOT NULL	Error Code for PY_DIRDEP AE program
34	PY_DDP_SB_STG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether Source Bank stage record should be used,
35	PY_DDP_DD_STG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate whether Direct Deposit stage record should be used,
36	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name
37	TABLE_NAME1	Character(30)	VARCHAR2(30) NOT NULL	Table Name
38	DESCR254B	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
39	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
40	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section