STEP_INCR_AET

(SQL Table)
Index Back

AE Cache Table for Step Incr

This table is used as cache record for the step increase prepare run.

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
6 FROMDATE Date(10) DATE From Date
7 DATE_TO Date(10) DATE Previous Period Date To
8 EFFDT Date(10) DATE Effective Date
9 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

10 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
11 NO_REVIEW Character(1) VARCHAR2(1) NOT NULL Review Required
12 BAL_ID_FOR_CAL_YR Character(2) VARCHAR2(2) NOT NULL Balance ID for Calendar Year
13 IF_FLAG Character(1) VARCHAR2(1) NOT NULL If flag
14 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
15 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
16 JOB_EFFDT Date(10) DATE Job Effective Date
17 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
18 STEP_ENTRY_DT Date(10) DATE Step Entry Date
19 INCREM_MONTHS Number(3,0) SMALLINT NOT NULL Months to Next Step Increment
20 NEW_EFFDT Date(10) DATE New Benefit Program Effdt