DLT_RESPN_ESPVW

(SQL View)
 Index Back

View Delt@ RATSB

View Delt@ RATSB

SELECT HDR.RUN_CNTL_ID , HDR.OPRID , EE.EMPLID , HDR.RESPONSIBLE_ID , HDR.STATE , HDR.DLT_STAFF_ESP , HDR.YEARCD , HDR.MONTHCD FROM PS_DLT_RC_EE_ESP EE , PS_DLT_RC_ESP HDR WHERE EE.XMLFILE_ID = HDR.XMLFILE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

4 REPRESNT_ID_ESP Character(11) VARCHAR2(11) NOT NULL Company Representative ID

Prompt Table: REPRESNTATV_ESP

5 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_NAMES_TBL

6 DLT_STAFF_ESP Character(5) VARCHAR2(5) NOT NULL Staff
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