AV_VOL_GRP_STRC(SQL Table) |
Index Back |
---|---|
Volunteer Group StructureThis table holds information on Volunteer group structures for a Membership Organization. |
# | 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 | Character(3) | VARCHAR2(3) NOT NULL |
Role
Prompt Table: AV_PRPS_VOL_VW2 |
|
7 | Character(1) | VARCHAR2(1) NOT NULL |
Required
N=No Y=Yes Default Value: N |
|
8 | VOL_NBR_REQ | Number(5,0) | INTEGER NOT NULL |
Number Needed
Default Value: 1 |
9 | 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 |
10 | VOL_SEL_PRCS | Character(1) | VARCHAR2(1) NOT NULL |
Selection Process
A=Appointed E=Elected Default Value: A |