ERE_XEE2_ESP_VW

(SQL View)
Index Back

ERE Procedure EE Data VW ESP

This view retrieves the employee data needed for ERE Procedure XML

SELECT B.OPRID , B.RUN_CNTL_ID , A.SSN_EMPLOYER , A.ERE_ID_ESP , A.EMPLID , A.EMPL_RCD , A.EFFDT , CASE WHEN A.ERE_U_ACTN_TYP_ESP = 'D' THEN A.EFFDT ELSE %DateNull END , A.ERE_EVENT_TYPE_ESP , A.ERE_U_ACTN_TYP_ESP , A.ERE_WKD_RD_PCT_ESP , CASE WHEN A.ERE_U_ACTN_TYP_ESP = 'P' THEN A.EFFDT ELSE %DateNull END , A.ERE_SCH_DST_ESP FROM PS_ERE_EE_VW_ESP A , PS_ERE_RC_XEE_ESP B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.BGN_DT AND A.ERE_ID_ESP = A.ERE_ID_ESP AND B.GENERATE_REPORT = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
4 ERE_ID_ESP Character(10) VARCHAR2(10) NOT NULL ERE ID
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: EMPLOYMENT

7 ERE_BGNDT_ESP Date(10) DATE ERE Begin date

Default Value: ERE_DATA_ESP.ERE_BGNDT_ESP

8 ERE_PRD_BGNDT_ESP Date(10) DATE Period Begin Date
9 ERE_EVENT_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL ERE Event Type A : New B : Delete M: Update
A=New
B=Delete
M=Update
10 ERE_U_ACTN_TYP_ESP Character(1) VARCHAR2(1) NOT NULL ERE Update action type
D=Daily Hours Reduction
P=Permanent
S=Suspension
W=Work Day Reduction
11 ERE_WKD_RD_PCT_ESP Number(6,2) DECIMAL(5,2) NOT NULL Work schedule reduction percentage
12 TERMINATION_DT Date(10) DATE Termination Date

Default Value: ERE_DATA_ESP.TERMINATION_DT

13 ERE_SCH_DST_ESP Character(1) VARCHAR2(1) NOT NULL Work schedule distribution
D=Daily Hours Reduction
W=Work Day Reduction

Default Value: ERE_DATA_ESP.ERE_SCH_DST_ESP