Body
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 |