DIR_DEP_CNTRLS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DIRDEP_NOTIFY	Character(1)	VARCHAR2(1) NOT NULL	Field is used to indicate notifications Y/N Table Edit Default Value: N
2	DIRDEP_NOTIFY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Fields is used to hold the notification type 1=Employee 2=Administrator 3=EE and Admin
3	DIRDEP_BANKID_CAN	Character(1)	VARCHAR2(1) NOT NULL	Used to note the bankID for Canada Y/N Table Edit Default Value: N
4	DIRDEP_ROUTING_US	Character(1)	VARCHAR2(1) NOT NULL	Used to note the routing number for US Y/N Table Edit Default Value: N
5	DIRDEP_NOTIFY_ROLE	Character(30)	VARCHAR2(30) NOT NULL	Used to note the Role for direct deposit notifications Prompt Table: DIR_DEP_RLE_VW2
6	DIRDEP_NOTIFY_PN	Character(1)	VARCHAR2(1) NOT NULL	Field is used to indicate notifications Y/N Table Edit Default Value: N
7	DIRDEP_NOTF_TYP_PN	Character(1)	VARCHAR2(1) NOT NULL	Fields is used to hold the notification type for DD Control. 1=Employee 2=Administrator 3=EE and Admin
8	DIRDEP_NOTF_ROL_PN	Character(30)	VARCHAR2(30) NOT NULL	Used to note the Role for direct deposit notifications Prompt Table: DIR_DEP_RLE_VW2
9	PRENOTE_REQD_ESS	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Reqd for ESS Y/N Table Edit Default Value: Y
10	REQ_REM_BAL_US	Character(1)	VARCHAR2(1) NOT NULL	Remaining balance check Y/N Table Edit
11	REQ_REM_BAL_CAN	Character(1)	VARCHAR2(1) NOT NULL	Remaining balance check Y/N Table Edit
12	REMOVE_CHK_US	Character(1)	VARCHAR2(1) NOT NULL	Restrict Check for USA Y/N Table Edit
13	REMOVE_CHK_CAN	Character(1)	VARCHAR2(1) NOT NULL	Restrict Check for CAN Y/N Table Edit
14	REM_LAST_ACC_USA	Character(1)	VARCHAR2(1) NOT NULL	Remove last account check Y/N Table Edit
15	REM_LAST_ACC_CAN	Character(1)	VARCHAR2(1) NOT NULL	Remove last account check Y/N Table Edit
16	SPRS_DDP_PRT_USA	Character(1)	VARCHAR2(1) NOT NULL	Supress Direct Deposit Print USA Y/N Table Edit
17	SPRS_DDP_PRT_CAN	Character(1)	VARCHAR2(1) NOT NULL	Supress Direct Deposit Print CAN Y/N Table Edit
18	MAX_DDP_ACC_USA	Number(3,0)	SMALLINT NOT NULL	Maximum Direct Deposit Accounts USA
19	MAX_DDP_ACC_CAN	Number(3,0)	SMALLINT NOT NULL	Maximum Direct Deposit Accounts CAN
20	DIRDEP_NOTIFY_EMPL	Character(1)	VARCHAR2(1) NOT NULL	Field is used to indicate notifications Y/N Table Edit Default Value: N
21	DIRDEP_NOTIFY_ADM	Character(1)	VARCHAR2(1) NOT NULL	Field is used to indicate notifications for Admin Y/N Table Edit Default Value: N
22	DIRDEP_NOTF_ROL_NC	Character(30)	VARCHAR2(30) NOT NULL	Used to note the Role for direct deposit notifications Prompt Table: DIR_DEP_RLE_VW2