HR_ROSTEXEC_AET

(SQL Table)
Index Back

HR - AE State Record

HR_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