GM_HRLOAD_AET

(SQL Table)
Index Back

Grants HR Data AE Cache Rec

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
9 SKIP_NEXT_STEP_SW Character(1) VARCHAR2(1) NOT NULL Skip Next Step
10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
11 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
12 PRENOTE_REQD Character(1) VARCHAR2(1) NOT NULL Prenotification Required