EMPLIDPrompt Table: PEOPLE_SRCH
INSTITUTIONPrompt Table: SSR_STU_INS
SSR_APT_INSTANCEPrompt Table: SSR_MP_APT_VW
SSR_ITEM_IDSSR_APT_TERMS(SQL View) |
Index Back |
|---|---|
Student APT Term Items |
| SELECT apt.EMPLID , apt.INSTITUTION , apt.SSR_APT_INSTANCE , air.SSR_ITEM_ID FROM PS_SSR_APT_HDR apt , PS_SSR_AIR_HDR_PRG prg , PS_SSR_PROG_FORM frm , PS_SSR_AIR_HDR air WHERE apt.INSTITUTION = prg.INSTITUTION AND apt.SSR_ITEM_ID = prg.SSR_ITEM_ID AND prg.INSTITUTION = frm.INSTITUTION AND prg.SSR_FORMAT_ID = frm.SSR_FORMAT_ID AND frm.INSTITUTION = air.INSTITUTION AND frm.SSR_ITEM_TYPE_EQT = air.SSR_ITEM_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: SSR_STU_INS |
| 3 | SSR_APT_INSTANCE |
Number(3,0) | SMALLINT NOT NULL |
Academic Progress Tracker Instance Number
Prompt Table: SSR_MP_APT_VW |
| 4 | SSR_ITEM_ID |
Character(11) | VARCHAR2(11) NOT NULL | Academic Item ID |