DIR_DEP_DIS_NLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
5	LEDGER_ACCOUNT_NLD	Character(17)	VARCHAR2(17) NOT NULL	Ledger Account Number
6	DEPOSIT_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount in Dollars
7	AMOUNT_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percent Amount
8	PAYMENT_TYPE_NLD	Character(1)	VARCHAR2(1) NOT NULL	Payment Type 1=Cash 2=Bank 3=Giro Default Value: 2
9	PAYMENT_DESCR_NLD	Character(64)	VARCHAR2(64) NOT NULL	Payment Description
10	ASCRIPTION_NLD	Character(20)	VARCHAR2(20) NOT NULL	Ascription
11	PAYMENT_RECIP_NLD	Character(2)	VARCHAR2(2) NOT NULL	Recipient Type 01=Net Pay 02=Savings Plan 03=Life Cycle Savings 04=Loan 05=Advance Payment 06=Garnishment 07=Mortgage 08=Other Default Value: 01
12	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: GPSC_CNT_DVW_FL
13	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
14	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: %GP_EDIT_FLD1
15	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
16	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: COUNTRY_CUR_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
18	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
19	INTL_BANK_ACCT_NBR	Character(34)	VARCHAR2(34) NOT NULL	IBAN International Bank Account Number
20	ROLL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Roll Name
21	ROLL_NUMBER	Character(20)	VARCHAR2(20) NOT NULL	Roll Number
22	IAT_IND	Character(1)	VARCHAR2(1) NOT NULL	International ACH Transaction Bank (or IAT) Indicator Y/N Table Edit Default Value: N