OPRCLASSINSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SAD_PB_FILEIDPrompt Table: SAD_PB_REPFIDVW
SAD_PB_CAS_NUMBEREMPLIDPrompt Table: SAD_PB_REPEIDVW
SAD_PB_REPSRCH(SQL View) |
Index Back |
|---|---|
Report Extract Seacrh RecordReportExtract Seacrh Record |
| SELECT pe.oprclass ,ext.institution ,ext.sad_pb_fileid , ext.sad_pb_cas_number ,ext.sad_pb_ext_date ,ext.emplid , pe.last_name_srch , pe.first_name_srch , pe.birthdate_msk ,ext.sad_pb_exclude FROM %Table(sad_pb_rep_ext) ext , %Table(people_srch) pe WHERE ext.emplid = pe.emplid |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 3 | SAD_PB_FILEID |
Character(50) | VARCHAR2(50) NOT NULL |
Report File ID
Prompt Table: SAD_PB_REPFIDVW |
| 4 | SAD_PB_CAS_NUMBER |
Character(14) | VARCHAR2(14) NOT NULL | CAS Number |
| 5 | SAD_PB_EXT_DATE | Date(10) | DATE | Extract Date |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SAD_PB_REPEIDVW |
| 7 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 8 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 9 | BIRTHDATE_MSK | Character(10) | VARCHAR2(10) NOT NULL | Date of Birth |
| 10 | SAD_PB_EXCLUDE | Character(1) | VARCHAR2(1) NOT NULL | Exclude from XML |