EXT_ORG_PRI_VW - External Org Primary View

This Table includes External organization  details - previous schools attended, high schools, etc.

Detailed Information

Data Systems

  • PeopleSoft Campus Solutions CSPRD 
  • Campus Solutions Reporting CSRPT
Key Record.Fieldname Format XLAT Heading Text
  ADDRESS1 - Address Line 1 Char55   Address 1
  ADDRESS2 - Address Line 2 Char55   Address 2
  ADDRESS3 - Address Line 3 Char55   Address 3
  ADDRESS4 - Address Line 4 Char55   Address 4
  ADDR_FIELD1 - Address Field 1 Char2   Address Field 1
  ADDR_FIELD2 - Address Field 2 Char4   Address Field 2
  ADDR_FIELD3 - Address Field 3 Char4   Address Field 3
  CITY - City Char30   City
  COUNTRY - Country Char3   Country
  COUNTY - County Char30   County
  DESCR - Description Char30   Descr
  DESCR50 - Description Char50   Descr
  DESCRSHORT - Short Description Char10   Short Desc
Key EFFDT - Effective Date Date   Eff Date
  EFF_STATUS - Status as of Effective Date Char1 N Status
Key EXT_ORG_ID - External Org ID Char11   Org ID
  EXT_ORG_TYPE - Organization Type Char4   Org Type
  GEO_CODE - Tax Vendor Geographical Code Char11   Geo Code
  HOUSE_TYPE - House Type Char2   House
  IN_CITY_LIMIT - In City Limit Char1   In Cty Lmt
  NUM1 - Number 1 Char6   Nbr 1
  NUM2 - Number 2 Char6   Nbr 2
  ORG_CONTACT - Contact Nbr Num4.0   Contact
  ORG_DEPARTMENT - Department Nbr Num3.0   Department
  ORG_LOCATION - Location Nbr Num3.0   Location
  OTH_NAME_SORT_SRCH - Search Name Char50   Srch Name
  POSTAL - Postal Code Char12   Postal
  PROPRIETORSHIP - Proprietorship Char4 N Ownership
  SETID - SetID Char5   SetID
  STATE - State Char6   State
  TAXPAYER_ID_NO - Taxpayer ID Number Char9   TIN
  VENDOR_ID - Vendor ID Char10   Vendor
Submit an Inquiry or Request to DARTS Print Article

Details

Article ID: 159613
Created
Mon 6/10/24 4:15 PM
Modified
Wed 8/7/24 8:36 AM
Applies To
Faculty
Staff
Community

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)