| Data element |
Definition |
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for org (non-individual) records. |
EFFDT
Indexed - No
Format - DATE
Nullable - N | Effective date of the table row. Tells you which data is most "up to date", and which rows have been changed. By definition, tables with an "MV" suffix only show the "most effective dated row", i.e. the current valid row. |
EFF_STATUS
Indexed - No
Format - VARCHAR2
Nullable - N | Effective status of data row ("A" = active, "I" = inactive). |
OTH_NAME_SORT_SRCH
Indexed - No
Format - VARCHAR2
Nullable - N | Search name. |
EXT_ORG_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | Organization type. |
SCHOOL_CODE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
LS_SCHOOL_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
FICE_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
ATP_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
ADDRESS1
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 1. In a business address row, this field will often house the business name. |
ADDRESS2
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 2. In a business address row, this field occasionally house the business name. |
ADDRESS3
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 3. |
ADDRESS4
Indexed - No
Format - VARCHAR2
Nullable - N | Address line 4. |
NUM1
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated |
NUM2
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
HOUSE_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
GEO_CODE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
CITY
Indexed - No
Format - VARCHAR2
Nullable - N | City description. |
IN_CITY_LIMIT
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
COUNTY
Indexed - No
Format - VARCHAR2
Nullable - N | County within state; sparsely populated in database |
STATE
Indexed - No
Format - VARCHAR2
Nullable - N | Two digit state code (ex. PA) |
POSTAL
Indexed - No
Format - VARCHAR2
Nullable - N | Zip code (for domestic zips, either 5 or nine digits, not formatted). |
COUNTRY
Indexed - No
Format - VARCHAR2
Nullable - N | Three digit country abbreviation (ex. 'USA') |
DESCR
Indexed - No
Format - VARCHAR2
Nullable - N | Organization Name |
DESCR50
Indexed - No
Format - VARCHAR2
Nullable - N | Organization Name |
DESCRSHORT
Indexed - No
Format - VARCHAR2
Nullable - N | Short Organization Name. |
ORG_CONTACT
Indexed - No
Format - NUMBER
Nullable - N | Number that corresponds to the primary contact record in the PS_ORG_CONTACT table. |
ORG_LOCATION
Indexed - No
Format - NUMBER
Nullable - N | Number that corresponds to the primary location record in the PS_ORG_LOCATION table. |
ORG_DEPARTMENT
Indexed - No
Format - NUMBER
Nullable - N | Number that corresponds to the primary department record in the PS_ORG_DEPT table. |
OFFERS_COURSES
Indexed - No
Format - VARCHAR2
Nullable - N | Yes no flag indicating that an organization is a school. |
PROPRIETORSHIP
Indexed - No
Format - VARCHAR2
Nullable - N | Indicates private vs. public, etc. |
ACT_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
IPEDS_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
SCHOOL_DISTRICT
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
ACCREDITED
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
TRANSCRIPT_XLATE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
UNT_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
EXT_TERM_TYPE
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
EXT_CAREER
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
SHARED_CATALOG
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
CATALOG_ORG
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
CHG_OTHER
Indexed - No
Format - VARCHAR2
Nullable - N | Not populated. |
SETID
Indexed - No
Format - VARCHAR2
Nullable - N | This is the Atlas five character code representing the Penn unit that owns a designation. SETIDs map to BEN accounting centers with a few exceptions. UPENN is the default SETID for PENN. Student Financial Services and the President's general university |
VENDOR_ID
Indexed - No
Format - VARCHAR2
Nullable - N | ID Field |
TAXPAYER_ID_NO
Indexed - No
Format - VARCHAR2
Nullable - N | Id Field |
UP_ADDR_SRC_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Code indicating the source of the address or name update. |
DATETIME_UPDATED
Indexed - No
Format - DATE
Nullable - Y | Date and time of the last record update |
OPRID
Indexed - No
Format - VARCHAR2
Nullable - N | Id of data entry operator |
FULL_NAME
Indexed - No
Format - VARCHAR2
Nullable - N | Organization name. |
