AV_VOL_ASGMT_VW(SQL View) |
Index Back |
|---|---|
Volunteer Asignment viewThis view selects information pertaining to a Volunteers history. |
| SELECT INSTITUTION , INTV_CD , AV_MBR_ORG_COD , STAFF_ID , SEQ_NO , START_DT , END_DT , YRS_SERVICE , ASGMT_TYPE , 0 , ' ' , ' ' , ' ' , ' ' FROM PS_AV_VOL_ASGMT |
| # | 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 | STAFF_ID |
Character(11) | VARCHAR2(11) NOT NULL | Staff ID |
| 5 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | end date |
| 8 | YRS_SERVICE | Number(5,2) | DECIMAL(4,2) NOT NULL | Yrs of Service |
| 9 | ASGMT_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Assignment Type
Prompt Table: AV_ASGN_TYP_TBL |
| 10 | VOL_STRCT_NBR | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Structure Nbr |
| 11 | PURPOSE_CD | Character(3) | VARCHAR2(3) NOT NULL | Role |
| 12 | VOL_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Required
N=No Y=Yes |
| 13 | 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 |
| 14 | VOL_SEL_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
Selection Process
A=Appointed E=Elected |