SETIDEXTRA_ACTIVITYEFFDTDefault Value: %date
A=Active
I=Inactive
ATHL=Athletics
CLUB=Club
EMPL=Employment
GOVT=Student Government
MUSC=Music
OTHR=Other
PUBL=Publications
THEA=Theater
VOLN=Volunteer
EXTR_ACT_EXT_VW(SQL View) |
Index Back |
|---|---|
External Extra Activity ViewEXTR_ACT_EXT_VW selects external Extracurricular Activities from EXTRA_ACTVTY_TBL (ie. activities which have been flag as 'External' or 'Both' external and internal). This view provides prompt support for EXTRA_ACTIVITY in the admissions module. |
| select a.setid ,a.extra_activity ,a.effdt ,a.eff_status ,a.descr ,a.extra_actvty_type from PS_EXTR_ACTVTY_TBL a where a.offered = 'E' or a.offered = 'B' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | EXTRA_ACTIVITY |
Character(6) | VARCHAR2(6) NOT NULL | Extracurricular Activity |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EXTRA_ACTVTY_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Activity Type
ATHL=Athletics CLUB=Club EMPL=Employment GOVT=Student Government MUSC=Music OTHR=Other PUBL=Publications THEA=Theater VOLN=Volunteer |