HR_ROSTEXEC_AET(SQL Table) |
Index Back |
---|---|
HR - AE State RecordHR_ROSTEXEC_AETState record. This record is accessed in App Engine HR_LAY_EXEC/ HR_RGT_EXEC/ HR_REIN_EXEC. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
3 | LABOR_AGREEMENT | Character(6) | VARCHAR2(6) NOT NULL | Labor Agreement |
4 | AE_TEST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Test Flag |
5 | LBR_RECALL_REASON | Character(10) | VARCHAR2(10) NOT NULL | Recall Reason |
6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
8 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
9 | LBR_MULT_TERMDT | Character(1) | VARCHAR2(1) NOT NULL | Multiple Term Dates? |
10 | TERMINATION_DT | Date(10) | DATE | Termination Date |
11 | LBR_PRCS_STAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Process Status?
Y/N Table Edit Default Value: N |
12 | LBR_CALLAPPENG_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine whether CallAppEngine was used
Y/N Table Edit Default Value: N |
13 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
14 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
15 | LBR_ROSTER_ID | Character(11) | VARCHAR2(11) NOT NULL | Roster ID |
16 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
17 | LBR_EVENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Type
L=Layoff R=Recall |
18 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
19 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
20 | LBR_PROP_TERM_DT | Date(10) | DATE | Proposed Termination Date |
21 | LBR_AUTO_REIN_FLG | Character(1) | VARCHAR2(1) NOT NULL | Auto Reinstatement |
22 | LBR_REINST_ACTION | Character(3) | VARCHAR2(3) NOT NULL | Reinstatement Action |
23 | LBR_REIN_ACTION_DT | Date(10) | DATE | Reinstatement Action Date |
24 | LBR_REINST_ACT_RSN | Character(3) | VARCHAR2(3) NOT NULL | Reinstatement Action Reason |
25 | LBR_REINST_DT | Date(10) | DATE | Reinstatement Date |
26 | LBR_EXPIRY_RULE_ID | Character(11) | VARCHAR2(11) NOT NULL | Labor Recall Expiry Rule ID |
27 | LBR_ACTUAL_TERM_DT | Date(10) | DATE | Actual Termination Date |
28 | REHIRE_DT | Date(10) | DATE | Rehire Date |
29 | LBR_RCL_EXPIRY_DT | Date(10) | DATE | Recall Expiration Date |