HR_SPLIB_AET

(SQL Table)
Index Back

AE Record for Group Build

AE Record for Group Build

# 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 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number
6 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
7 SP_PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
10 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
11 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

12 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
13 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan
14 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade
15 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
16 STEP Number(2,0) SMALLINT NOT NULL Step
17 STEP_ENTRY_DT Date(10) DATE Step Entry Date
18 BUDGET_START_DT Date(10) DATE Budget Start Date
19 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
20 AE_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL Test Flag
21 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
22 RECORD_NAME Character(18) VARCHAR2(18) NOT NULL Record Name
23 CMP_DONT_ABSORB Character(1) VARCHAR2(1) NOT NULL Don't Absorb Changes
N=No
Y=Yes
24 UPD_FUTURE_ROW_SW Character(1) VARCHAR2(1) NOT NULL Update Future Rows
N=No
Y=Yes
25 AE_STEP Character(8) VARCHAR2(8) NOT NULL Name