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 | 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 |