INSTITUTIONINTV_CDAV_MBR_ORG_CODVOL_GRP_NBREFFDTVOL_STRCT_NBRVOL_NBRSEQ_NOPrompt Table: AV_STAFF_VOL_VW
AV_VOL_ASGN2_VW(SQL View) |
Index Back |
|---|---|
Volunteer Asignment ViewThis is a view of the table that holds all Volunteer Asignment information. 5/4/01 (JPM) - Added EFFDT field to this view and made it a descending key. |
| SELECT INSTITUTION , INTV_CD , AV_MBR_ORG_COD , VOL_GRP_NBR , EFFDT , VOL_STRCT_NBR , VOL_NBR , SEQ_NO , STAFF_ID , START_DT , END_DT , YRS_SERVICE FROM PS_AV_VOL_ASGN_TBL |
| # | 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 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | VOL_STRCT_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | Volunteer Structure Nbr |
| 7 | VOL_NBR |
Number(6,0) | INTEGER NOT NULL | Volunteer Nbr |
| 8 | SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 9 | STAFF_ID | Character(11) | VARCHAR2(11) NOT NULL |
Staff ID
Prompt Table: AV_STAFF_VOL_VW |
| 10 | START_DT | Date(10) | DATE NOT NULL | Start Date |
| 11 | END_DT | Date(10) | DATE | end date |
| 12 | YRS_SERVICE | Number(5,2) | DECIMAL(4,2) NOT NULL | Yrs of Service |