FS_HREMP_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
3	ADVANCE_LVL	Character(1)	VARCHAR2(1) NOT NULL	Cash Advance Level B=Business Unit N=None S=Specific Amount
4	ADV_MAX_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cash Advance Maximum
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
7	BANK_ID_QUAL	Character(3)	VARCHAR2(3) NOT NULL	"A bank/counterparty attribute that determines
8	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
9	BANK_CHAR	Character(1)	VARCHAR2(1) NOT NULL	Bank Code Character
10	BANK_SEQ_NBR	Number(4,0)	SMALLINT NOT NULL	Bank Code Sequence Number
11	BANK_SEQ_LAST	Number(5,0)	INTEGER NOT NULL	Last Bank Code Sequence
12	BANK_SEQ_CHAR4	Character(4)	VARCHAR2(4) NOT NULL	Bank Sequence Character 4
13	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code
14	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
15	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
16	BANK_CHAR_NEXT	Character(1)	VARCHAR2(1) NOT NULL	Next Bank Code Character
17	BNK_ID_NBR	Character(20)	VARCHAR2(20) NOT NULL	A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
18	SKIP_NEXT_STEP_SW	Character(1)	VARCHAR2(1) NOT NULL	Skip Next Step
19	BANK_ACCOUNT_NUM	Character(35)	VARCHAR2(35) NOT NULL	The literal unique identifier associated with a given bank/counterparty account.
20	BRANCH_ID	Character(10)	VARCHAR2(10) NOT NULL	The local branch office identifier associated with a given bank/counterparty.
21	BANK_ACCT_KEY	Character(4)	VARCHAR2(4) NOT NULL	A user defined unique identifier that facilitates the identification of a given account with a given bank
22	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
23	PYMNT_METHOD_EX	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House CHK=System Check EFT=Electronic Funds Transfer GE=Giro - EFT
24	PRENOTE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Required
25	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
26	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
27	LOAD_HR_BNK_ACCT	Character(1)	VARCHAR2(1) NOT NULL	Change Default to Highest Priority Bank Account When Existing Default Account Priority Changed