| Data element |
Definition |
| Email_Address Indexed - no
Format - Varchar2(200)
May be Null? Y | Email Address |
| Emergency_Contact_Email Indexed - no
Format - Varchar2(100)
May be Null? Y | Email Address for emergency contact. |
| Emergency_Contact_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Name of emergency contact. |
| Emergency_Contact_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Phone number for emergency contact. |
| Emergency_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Emergency Phone number. |
| Employeee_Home_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | 4 digit Home ORG code if an active employee. |
| Faculty_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is this person currently an active Faculty member(Y/N)?
Set to ''Y'' if the individual has one of the following active Affiliation codes in Penn Community:
ADJF, FAC, SFAC, VFAC, WFAC |
| First_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | First Name |
| Id Indexed - yes
Format - Number
May be Null? N | Identifier for a person to a trip or group in Global Activities Registry - not unique, each row is associated with a particular trip or is a leader or admin for a group. |
| Last_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Last Name |
| Middle_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Middle Name |
| Penn_Id Indexed - no
Format - Number
May be Null? Y | Penn Id |
| Primary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Primary Phone number. |
| Secondary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Not used. Secondary Phone number. |
| SRS_Home_Division
Indexed - no
Format - Varchar2(3)
May be Null? Y | If a student, the SRS Division for the current academic term and degree order of 1.
Examples "ASP", "BMP","CGS","COL", ... "WHP"' |
| SRS_Home_School
Indexed - no
Format - Varchar2(40)
May be Null? Y | If a student, the SRS School for the current academic term and degree order of 1. |
| Student_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is this person currently an active Student(Y/N)? Set to ''Y'' if the individual is an has active student affiliation in Penn Community:
NOTE: Students who are inactivated in PennCommunity will have the Student_Flag set to 'N', causing a decrease in counts of trips made by students.
|
