GPDE_BK_TRN_AET

(SQL Table)
Index Back

Prepare Payment Cache Record

Prepare Payment Process Cache Record

# 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
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
7 EMPLID_FROM Character(11) VARCHAR2(11) NOT NULL EMPLID (first for a range)
8 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To
9 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
10 ORG_LINK_OPTN Character(2) VARCHAR2(2) NOT NULL Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group
CO=Company
DE=Department
ET=Establishment
LO=Location
PG=Pay Group
11 RUN_CALC_IND Character(1) VARCHAR2(1) NOT NULL Calculate Payees

Y/N Table Edit

Default Value: N

12 RUN_FINAL_IND Character(1) VARCHAR2(1) NOT NULL Finalize Entire Run
13 UPDATE_STATS_IND Character(1) VARCHAR2(1) NOT NULL Update Statistics
14 PRD_END_DT Date(10) DATE Pay Period End Date
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 GPDE_IC_CONTINUE_R Character(1) VARCHAR2(1) NOT NULL Continue Program Run
17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
18 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
19 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Root Package ID
20 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL Qualified Package/Class Path
21 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
22 GPDE_CT_XMLSTRING Long Character CLOB XML String