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 |