OSP WL RV COMMENT SUMMARY Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AGGREGATOR_ID |
XXX |
VARCHAR2 |
12 |
AL_FLAG |
XXX |
NUMBER |
|
AL_ID |
XXX |
VARCHAR2 |
9 |
AL_NAME |
XXX |
VARCHAR2 |
90 |
CANNED_REVIEW_COMMENT_CODE |
XXX |
NUMBER |
|
CA_FLAG |
XXX |
NUMBER |
|
CA_ID |
XXX |
VARCHAR2 |
9 |
CA_NAME |
XXX |
VARCHAR2 |
90 |
CR_FLAG |
XXX |
NUMBER |
|
CR_ID |
XXX |
VARCHAR2 |
9 |
CR_NAME |
XXX |
VARCHAR2 |
90 |
DESCRIPTION |
the description |
VARCHAR2 |
2000 |
DEV_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
8 |
DL_ID |
XXX |
VARCHAR2 |
9 |
DL_NAME |
XXX |
VARCHAR2 |
90 |
INST_PROPOSAL_NUMBER |
XXX |
VARCHAR2 |
8 |
PROPOSAL_NUMBER |
A unique number assigned by OSP to each proposal submitted to a sponsor. |
VARCHAR2 |
8 |
SPONSOR_CODE |
Sponsor code. OSP accounts are coded. Fund accounts are coded if there are restrictions in the award that make accounting system controls desirable. Contracts or grants from federal government and other restrictive sponsors are coded. |
VARCHAR2 |
12 |
SPONSOR_GROUP |
XXX |
VARCHAR2 |
50 |
SPONSOR_TYPE_CODE |
Numerical code identifing the type of sponsor (Example: 0 - Federal, 3 - Private-Pofit, 4 - Private-Non-Profit, 1 - State, etc?.) |
NUMBER |