AV_ACCT_INTV_VW(SQL View) |
Index Back |
---|---|
Initiative Camp/MBR ViewThis is a view of Initiatives that are of Type = Campaign or Membership. To be used as a prompt table/search record. |
SELECT DISTINCT A.INSTITUTION , B.EMPLID , B.ext_org_id , A.INTV_CD , A.DESCR60 , A.DESCR60_SRCH , A.START_DT , A.END_DT FROM PS_AV_INTV_TBL A ,PS_AV_RCG_DES B WHERE A.INSTITUTION =B.INSTITUTION AND A.INTV_CD = B.INTV_CD AND INTV_TYPE = 'CAMPAIGN' |
# | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
3 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
4 | INTV_CD | Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |
5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
6 | DESCR60_SRCH | Character(60) | VARCHAR2(60) NOT NULL | Formal Description |
7 | START_DT | Date(10) | DATE | Start Date |
8 | END_DT | Date(10) | DATE | end date |