ERE_XEE_ESP_VW

(SQL View)
 Index Back

Comp Certif EE Data VW ESP

Company Certificate Employee Data.

SELECT B.OPRID , B.RUN_CNTL_ID , A.SSN_EMPLOYER , A.ERE_ID_ESP , A.EMPLID , A.EMPL_RCD , B.YEARCD , B.MONTHCD 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.ERE_ID_ESP = B.ERE_ID_ESP AND A.ERE_TYPE_ESP = B.ERE_TYPE_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 YEARCD Character(4) VARCHAR2(4) NOT NULL Calendar Year
8 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December