AV_VOL_ROLE_TBL(SQL Table) |
Index Back |
---|---|
Volunteer Role tableThis table defines the Volunteers affiliation with a Vol.group. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution | |
2 | Character(10) | VARCHAR2(10) NOT NULL | Initiative Code | |
3 | Character(10) | VARCHAR2(10) NOT NULL | Member Organization Code | |
4 | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Group | |
5 | Date(10) | DATE | Effective Date | |
6 | Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Structure Nbr | |
7 | Number(6,0) | INTEGER NOT NULL | Volunteer Nbr | |
8 | PURPOSE_CD | Character(3) | VARCHAR2(3) NOT NULL | Role |
9 | VOL_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Required
N=No Y=Yes |
10 | 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 |
11 | VOL_SEL_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
Selection Process
A=Appointed E=Elected |