| Data element |
Definition |
LAST_EXTRACT_DATE
Indexed - yes
Format - date
May be null? no |
The date this record was extracted from the Research Services system
and loaded into the Warehouse. This information is stored in the Warehouse
in date format. In Business Objects, it is displayed as specified in the
desktop operating system settings. It is recommended that users specify
a date format that includes 4 digits for the year. (To specify the date
format in Windows 95, choose the Regional Settings of the Control Panel,
select the Date tab and specify the Short date style. In Windows, use
the International option of the Control Panel. On the Macintosh, use the
Date & Time Control Panel.) Example: 9/22/1997.
Values:
List of values not available.
|
PROJECT_ID
Indexed - no
Format - char (5)
May be null? no |
A 5-digit code identifying the project using the subcontractor.
PROJECT_ID is used as the first five characters of the PROPOSAL_ID. See
also PROPOSAL_ID in the SPON_PROJ_SUBCONTRACTOR Table. Example: 54321.
Values:
00000 to 99999
|
PROPOSAL_ID
Indexed - yes
Format - char (9)
May be null? no |
The 9-digit code identifying the sponsored project proposal
or award/prime account using the subcontractor. Example: 553209101. The
first five digits make up the project id. (See also PROJECT_ID in the SPON_PROJ_SUBCONTRACTOR
Table.) The next two digits identify the funds supplement (which may be
00 for proposals). The last two digits are meaningless for proposals; for
awards, they identify the account sequence number--01 indicates the prime
account, if the award has been split into more than one account, or the
only account, if the award has not been split. Note that for some awards
dating from before November 24, 1997, the last four characters are unreliable.
(To make up an example, 123450003 is actually the record for the prime account
for the first funds supplement--the award id should have been 123450101.)
Also note that in the Research Services transaction processing system, the
last two digits will always be 00 for records dating from November 24, 1997
and thereafter.)
Values:
List of values not available.
|
SUB_CONTRACTOR_AMOUNT
Indexed - no
Format - number (9)
May be null? yes |
The amount awarded by the University to the subcontractor
for the proposal or award for the grant/contract period. This is populated
only for records dating from November 24, 1997 and thereafter. See SUB_CONTRACTOR_AMOUNT
in the PROPOSAL and AWARD tables for the total amount awarded to all subcontractors
for the award or proposal.
Values:
0 to 999999999
|
SUB_CONTRACTOR_CODE
Indexed - yes
Format - char (2)
May be null? no |
The 2-character code used to identify a subcontractor for
the sponsored project. A sponsored project may use more than one subcontractor.
Example: DP (DUPONT)
Values:
AA to ZZ
Refer to the SUB_CONTRACTOR Table for values.
|
