S_PA_SHARR_S (ver 18.4.0)
This table is a stand alone table, and is used to store SHARR Contacts data.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 18.4.0 | Number(11,0) | System generated Primary Key. |
DentalProgram | 18.4.0 | Varchar2(4) | Dental program for SHARR. |
EmailAddress | 18.4.0 | Varchar2(50) | PENN*LINK email address. |
InstitutionType | 18.4.0 | Varchar2(4) | Institution Type for SHARR. |
PrimaryContact1_EmailAddress | 18.4.0 | Varchar2(50) | Email for Primary contact1 . |
PrimaryContact1_Ext | 18.4.0 | Varchar2(30) | Ext for Primary contact1 . |
| PrimaryContact1_FirstName | 18.4.0 | Varchar2(50) | First name for Primary contact1 |
| PrimaryContact1_LastName | 18.4.0 | Varchar2(50) | Last name for Primary contact1 |
| PrimaryContact1_PhoneNumber | 18.4.0 | Varchar2(30) | Phone number for Primary contact1 |
| PrimaryContact1_Title | 18.4.0 | Varchar2(4) | Title for Primary contact1 |
| PrimaryContact2_EmailAddress | 18.4.0 | Varchar2(50) | Email for Primary contact2 . |
| PrimaryContact2_EXT | 18.4.0 | Varchar2(30) | Ext for Primary contact2 |
| PrimaryContact2_FirstName | 18.4.0 | Varchar2(50) | First name for Primary contact2 |
| PrimaryContact2_LastName | 18.4.0 | Varchar2(50) | Last name for Primary contact2 |
| PrimaryContact2_PhoneNumber | 18.4.0 | Varchar2(30) | Phone number for Primary contact2 |
| PrimaryContact2_Title | 18.4.0 | Varchar2(4) | Title for Primary contact2 |
| SchoolID | 18.4.0 | Number(11) | School for SHARR |
| Current_Record_TF | 18.5.0 | Number(1,0) | Indicates the school's current SHARR record. |