OPRCLASSINSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
SAD_PB_FILEIDPrompt Table: SAD_PB_UPLFIDVW
C=Child
G=General
EMPLIDPrompt Table: SAD_PB_UPLEIDVW
SAD_PB_UPLSRCH(SQL View) |
Index Back |
|---|
| SELECT pe.oprclass , ext.institution ,ext.sad_pb_fileid ,ext.sad_pb_ext_date ,conf.sad_pb_category ,ext.emplid , pe.last_name_srch , pe.first_name_srch , pe.birthdate_msk ,ext.sad_pb_exclude FROM %Table(sad_pb_upl_ext) ext , %Table(people_srch) pe ,%Table(sad_pb_config) conf WHERE ext.emplid = pe.emplid AND ext.institution = conf.institution |
| # | 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 |
Upload File ID
Prompt Table: SAD_PB_UPLFIDVW |
| 4 | SAD_PB_EXT_DATE | Date(10) | DATE | Extract Date |
| 5 | SAD_PB_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Category
C=Child G=General |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: SAD_PB_UPLEIDVW |
| 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 |