OSP ORGANIZATION Table
View exposing organizational unit assignments to sponsored projects including department assignments, lab affiliations, school associations, and administrative responsibilities used for organizational project tracking and cost allocation.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS |
Address associated with the record. |
VARCHAR2 |
60 |
AGENCY_SYMBOL |
Agency symbol associated with the record. |
VARCHAR2 |
30 |
ANIMAL_WELFARE_ASSURANCE |
Animal welfare assurance associated with the record. |
VARCHAR2 |
20 |
CABLE_ADDRESS |
Cable address associated with the record. |
VARCHAR2 |
20 |
CAGE_NUMBER |
Cage number associated with the record. |
VARCHAR2 |
20 |
COGNIZANT_AUDITOR |
Cognizant auditor associated with the record. |
NUMBER |
|
COM_GOV_ENTITY_CODE |
Code identifying com gov entity. |
VARCHAR2 |
30 |
CONGRESSIONAL_DISTRICT |
Congressional district associated with the record. |
VARCHAR2 |
50 |
CONTACT_ADDRESS_ID |
Business identifier for the contact address. |
NUMBER |
|
COUNTY |
County associated with the record. |
VARCHAR2 |
30 |
DODAC_NUMBER |
Dodac number associated with the record. |
VARCHAR2 |
20 |
DUNS_NUMBER |
Duns number associated with the record. |
VARCHAR2 |
20 |
DUNS_PLUS_FOUR_NUMBER |
Duns plus four number associated with the record. |
VARCHAR2 |
20 |
FEDRAL_EMPLOYER_ID |
Business identifier for the fedral employer. |
VARCHAR2 |
15 |
HUMAN_SUB_ASSURANCE |
Human sub assurance associated with the record. |
VARCHAR2 |
30 |
INCORPORATED_DATE |
Date associated with incorporated. |
DATE |
|
INCORPORATED_IN |
Incorporated in associated with the record. |
VARCHAR2 |
50 |
INDIRECT_COST_RATE_AGREEMENT |
Indirect cost rate agreement associated with the record. |
VARCHAR2 |
50 |
IRS_TAX_EXCEMPTION |
Irs tax excemption associated with the record. |
VARCHAR2 |
30 |
MASS_EMPLOYEE_CLAIM |
Mass employee claim associated with the record. |
VARCHAR2 |
30 |
MASS_TAX_EXCEMPT_NUM |
Mass tax excempt num associated with the record. |
VARCHAR2 |
30 |
NSF_INSTITUTIONAL_CODE |
Code identifying nsf institutional. |
VARCHAR2 |
30 |
NUMBER_OF_EMPLOYEES |
Number of employees associated with the record. |
NUMBER |
|
ONR_RESIDENT_REP |
Onr resident rep associated with the record. |
NUMBER |
|
ORGANIZATION_ID |
Business identifier for the organization. |
VARCHAR2 |
8 |
ORGANIZATION_NAME |
Organization name associated with the record. |
VARCHAR2 |
60 |
PHS_ACOUNT |
Phs acount associated with the record. |
VARCHAR2 |
30 |
SCIENCE_MISCONDUCT_COMPL_DATE |
Date associated with science misconduct compl. |
DATE |
|
TELEX_NUMBER |
Telex number associated with the record. |
VARCHAR2 |
20 |
UPDATE_TIMESTAMP |
Timestamp associated with update. |
DATE |
|
UPDATE_USER |
Update user associated with the record. |
VARCHAR2 |
60 |
VENDOR_CODE |
Code identifying vendor. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |