INSTITUTIONPrompt Table: INSTITUTION_TBL
INTV_CDPrompt Table: AV_INTV_TBL
INTV_CD_RELATEDPrompt Table: AV_INTV_RLTD_VW
Prompt Table: AV_INTV_TYP_TBL
Default Value: 1
AV_INTV_REL_VW(SQL View) |
Index Back |
|---|---|
Related Initiatives Person vw. |
| SELECT A.INSTITUTION , A.INTV_CD , A.INTV_CD_RELATED , A.INTV_TYPE_RELATED , B.REPORTING_LEVEL , C.STAFF_ID , C.EFFDT FROM PS_AV_INTV_RELATED A , PS_AV_INTV_TBL B , PS_AV_INTV_PERSON C WHERE A.INSTITUTION = B.INSTITUTION AND A.INTV_CD_RELATED = B.INTV_CD AND A.INSTITUTION = C.INSTITUTION AND A.INTV_CD_RELATED = C.INTV_CD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_AV_INTV_PERSON C1 WHERE C1.INSTITUTION = C.INSTITUTION AND C1.INTV_CD = C.INTV_CD AND C1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | INTV_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Initiative Code
Prompt Table: AV_INTV_TBL |
| 3 | INTV_CD_RELATED |
Character(10) | VARCHAR2(10) NOT NULL |
Related Initiative Code
Prompt Table: AV_INTV_RLTD_VW |
| 4 | INTV_TYPE_RELATED | Character(10) | VARCHAR2(10) NOT NULL |
Related Initiative Type
Prompt Table: AV_INTV_TYP_TBL |
| 5 | REPORTING_LEVEL | Number(3,0) | SMALLINT NOT NULL |
Indicates the subordinate role that the initiative in context holds, 1 being highest with no peers.
Default Value: 1 |
| 6 | STAFF_ID | Character(11) | VARCHAR2(11) NOT NULL | Staff ID |
| 7 | AV_DATE | Date(10) | DATE | Date |