OSP ORGANIZATION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS |
XXX |
VARCHAR2 |
60 |
AGENCY_SYMBOL |
XXX |
VARCHAR2 |
30 |
ANIMAL_WELFARE_ASSURANCE |
XXX |
VARCHAR2 |
20 |
CABLE_ADDRESS |
XXX |
VARCHAR2 |
20 |
CAGE_NUMBER |
Sponsor CAGE code from COEUS |
VARCHAR2 |
20 |
COGNIZANT_AUDITOR |
XXX |
NUMBER |
|
COM_GOV_ENTITY_CODE |
XXX |
VARCHAR2 |
30 |
CONGRESSIONAL_DISTRICT |
XXX |
VARCHAR2 |
50 |
CONTACT_ADDRESS_ID |
XXX |
NUMBER |
|
COUNTY |
XXX |
VARCHAR2 |
30 |
DODAC_NUMBER |
Sponsor DODAC number from COEUS |
VARCHAR2 |
20 |
DUNS_NUMBER |
XXX |
VARCHAR2 |
20 |
DUNS_PLUS_FOUR_NUMBER |
Duns plus four number from COEUS |
VARCHAR2 |
20 |
FEDRAL_EMPLOYER_ID |
XXX |
VARCHAR2 |
15 |
HUMAN_SUB_ASSURANCE |
XXX |
VARCHAR2 |
30 |
INCORPORATED_DATE |
XXX |
DATE |
|
INCORPORATED_IN |
XXX |
VARCHAR2 |
50 |
INDIRECT_COST_RATE_AGREEMENT |
XXX |
VARCHAR2 |
50 |
IRS_TAX_EXCEMPTION |
XXX |
VARCHAR2 |
30 |
MASS_EMPLOYEE_CLAIM |
XXX |
VARCHAR2 |
30 |
MASS_TAX_EXCEMPT_NUM |
XXX |
VARCHAR2 |
30 |
NSF_INSTITUTIONAL_CODE |
XXX |
VARCHAR2 |
30 |
NUMBER_OF_EMPLOYEES |
XXX |
NUMBER |
|
ONR_RESIDENT_REP |
XXX |
NUMBER |
|
ORGANIZATION_ID |
The department, for example, Accounting. |
VARCHAR2 |
8 |
ORGANIZATION_NAME |
The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator. |
VARCHAR2 |
60 |
PHS_ACOUNT |
XXX |
VARCHAR2 |
30 |
SCIENCE_MISCONDUCT_COMPL_DATE |
XXX |
DATE |
|
TELEX_NUMBER |
Telex number. |
VARCHAR2 |
20 |
UPDATE_TIMESTAMP |
Date that a record was last updated by OSP. |
DATE |
|
UPDATE_USER |
Userid of the person who last updated this record. |
VARCHAR2 |
60 |
VENDOR_CODE |
XXX |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |