HR_SPLIB_AET(SQL Table) |
Index Back |
---|---|
AE Record for Group BuildAE 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 |