AV_VOL_ASG_VW(SQL View) |
Index Back |
---|---|
Volunteer Assignment ViewVolunteer Assignment View |
SELECT A.INSTITUTION, A.INTV_CD, A.AV_MBR_ORG_COD, A.VOL_GRP_NBR, A.VOL_STRCT_NBR, A.VOL_NBR, A.SEQ_NO, A.STAFF_ID, A.START_DT, A.END_DT, A.YRS_SERVICE, B.PURPOSE_CD, B.VOL_REQ, B.VOL_TERM_LNGTH, B.VOL_SEL_PRCS FROM PS_AV_VOL_ASGN_TBL A, PS_AV_VOL_ROLE_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.INTV_CD = B.INTV_CD AND A.AV_MBR_ORG_COD = B.AV_MBR_ORG_COD AND A.VOL_GRP_NBR = B.VOL_GRP_NBR AND A.VOL_STRCT_NBR = B.VOL_STRCT_NBR AND A.VOL_NBR = B.VOL_NBR |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
2 | INTV_CD | Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |
3 | AV_MBR_ORG_COD | Character(10) | VARCHAR2(10) NOT NULL | Member Organization Code |
4 | VOL_GRP_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Group |
5 | VOL_STRCT_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Structure Nbr |
6 | VOL_NBR | Number(6,0) | INTEGER NOT NULL | Volunteer Nbr |
7 | SEQ_NO | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
8 | STAFF_ID | Character(11) | VARCHAR2(11) NOT NULL |
Staff ID
Prompt Table: AV_STAFF_VOL_VW |
9 | START_DT | Date(10) | DATE | Start Date |
10 | END_DT | Date(10) | DATE | end date |
11 | YRS_SERVICE | Number(5,2) | DECIMAL(4,2) NOT NULL | Yrs of Service |
12 | PURPOSE_CD | Character(3) | VARCHAR2(3) NOT NULL | Role |
13 | VOL_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Required
N=No Y=Yes |
14 | VOL_TERM_LNGTH | Character(2) | VARCHAR2(2) NOT NULL |
Term Length
1=One Year 10=Ten Years 11=Eleven Years 12=Twelve Years 13=Thirteen Years 14=Fourteen Years 15=Fifteen Years 2=Two Years 3=Three Years 4=Four Years 5=Five Years 6=Six Years 7=Seven Years 8=Eight Years 9=Nine Years N=< One Year |
15 | VOL_SEL_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
Selection Process
A=Appointed E=Elected |