HI_GP_POST_AET

(SQL Table)
Index Back

Finalize GL Cache Record E1

Finalize GL Cache Record E1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GP_CAL_RUN1_VW

5 POSTING_DATE Date(10) DATE Posting Date
6 HPIP_BK_SUSP Character(1) VARCHAR2(1) NOT NULL Book to Suspense Account
7 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
8 EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL EMPLID (first for a range)
9 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To
10 PRD_TYPE Character(1) VARCHAR2(1) NOT NULL Period Type
C=Current
R=Retro
11 FORWARD_IND Character(1) VARCHAR2(1) NOT NULL Y/N indicates whether the delta from a retroactive recalc should be forwarded into the current calculation or not
12 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
16 RUN_CALC_IND Character(1) VARCHAR2(1) NOT NULL Calculate Payees

Y/N Table Edit

Default Value: N

17 RUN_FINAL_IND Character(1) VARCHAR2(1) NOT NULL Finalize Entire Run

Y/N Table Edit

Default Value: N

18 UPDATE_STATS_IND Character(1) VARCHAR2(1) NOT NULL Update Statistics
19 RUN_OPEN_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicates that processing has been initiated for given run (calendar group).
20 HPIP_VALID_STATUS Character(1) VARCHAR2(1) NOT NULL Validation status
21 OVERRIDE_IND Character(1) VARCHAR2(1) NOT NULL Override Indicator

Y/N Table Edit

Default Value: N

22 HPIP_BALANCE Character(1) VARCHAR2(1) NOT NULL Balance Accounting Lines

Y/N Table Edit