INSTITUTIONDefault Value: AV_OPR_DEF_TBL.INSTITUTION
Prompt Table: INSTITUTN_SCRTY
RSP_ASGN_TYPES=Staff
U=Unit
V=Volunteer
RSPL_IDPrompt Table: AV_ASGN_TYP_VW
FISCAL_YEARPrompt Table: AV_FISCAL_VW
AV_PRSGOAL_SRCH(SQL View) |
Index Back |
|---|---|
Prospect Resource Goals - SrchSearch Record for - Prospect Resource Goals |
| SELECT A.INSTITUTION , A.RSP_ASGN_TYPE , A.RSPL_ID , A.FISCAL_YEAR , A.AV_PERIOD , B.NAME , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.DESCR FROM %Table(AV_PRS_RSR_GLS) A LEFT OUTER JOIN PS_AV_ASGN_TYP_VW B ON A.INSTITUTION = B.INSTITUTION AND A.RSP_ASGN_TYPE = B.RSP_ASGN_TYPE AND A.RSPL_ID = B.RSPL_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
| 2 | RSP_ASGN_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Responsible person assignment type
S=Staff U=Unit V=Volunteer |
| 3 | RSPL_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Responsible
Prompt Table: AV_ASGN_TYP_VW |
| 4 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: AV_FISCAL_VW |
| 5 | AV_PERIOD | Number(3,0) | SMALLINT NOT NULL | Period |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |