| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
INSTID |
Character(5) |
VARCHAR2(5) NOT NULL |
Institution ID
Prompt Table:
GM_INSTITUTION
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
INSTID_REPORTS_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
Reports to Institution ID
Prompt Table:
GM_INSTITUTION
|
| 6 |
FEDERAL_EIN_GM |
Character(30) |
VARCHAR2(30) NOT NULL |
Federal EIN
|
| 7 |
TAXPAYER_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
Taxpayer ID
|
| 8 |
COST_LIV_INCR_PCT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Cost of Living Increase Pct
|
| 9 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 10 |
FA_INST_BASE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
FA_INST_BASE_ID
Prompt Table:
GM_FA_BASE_DTL
|
| 11 |
ACCOUNTING_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Accounting Basis
A=Accrual
C=Cash
Default Value: C
|
| 12 |
NIH_IPF_NBR |
Character(14) |
VARCHAR2(14) NOT NULL |
NIH IPF Number
|
| 13 |
INST_OFFICER |
Character(11) |
VARCHAR2(11) NOT NULL |
Institution Officer
Prompt Table:
PERSONAL_DATA
|
| 14 |
ALASK_SER_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Alaska Native Serving Institu
Y/N Table Edit
|
| 15 |
COOPER_EXTEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Cooperative Extension Service
Y/N Table Edit
|
| 16 |
HISPAN_SEV_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Hispanic Serving Institution
Y/N Table Edit
|
| 17 |
HISTOR_BLK_UNV |
Character(1) |
VARCHAR2(1) NOT NULL |
Historically Black College
Y/N Table Edit
|
| 18 |
MIN_SEV_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Minority Serving Institution
Y/N Table Edit
|
| 19 |
NAT_HAW_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Native Hawaiian Serving Instit
Y/N Table Edit
|
| 20 |
PUB_NO_PROF_COMCOL |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Nonprofit College
Y/N Table Edit
|
| 21 |
PUB_SECON_SCHL |
Character(1) |
VARCHAR2(1) NOT NULL |
Public Secondary School
Y/N Table Edit
|
| 22 |
SCH_OF_FORESTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
School of Forestry
Y/N Table Edit
|
| 23 |
STATE_AGR_EXP_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
State Agricultural Experiment
Y/N Table Edit
|
| 24 |
TRIBAL_COLLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Tribal College
Y/N Table Edit
|
| 25 |
VETER_SCH_COLLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Veterinary Scholar College
Y/N Table Edit
|
| 26 |
ADD_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Additional Applicant Type
Prompt Table:
GM_INS_ADD_TYPE
|
| 27 |
INS_KEYWORD |
Character(100) |
VARCHAR2(100) NOT NULL |
KeyWords
|
| 28 |
HHS_PMS_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
DHHS -PMS
Y/N Table Edit
|
| 29 |
DHHS_PMS_PIN |
Character(8) |
VARCHAR2(8) NOT NULL |
DHHS-PMS PIN
|
| 30 |
ORG_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
OrganizationType
Prompt Table:
GM_ORG_TYPE
|
| 31 |
GM_AWARDED |
Character(1) |
VARCHAR2(1) NOT NULL |
Ever received grant/contract
Y/N Table Edit
Default Value: N
|
| 32 |
GM_FAITH_BASED |
Character(1) |
VARCHAR2(1) NOT NULL |
A faith-based organization
Y/N Table Edit
Default Value: N
|
| 33 |
GM_SECULAR |
Character(1) |
VARCHAR2(1) NOT NULL |
A secular organization
Y/N Table Edit
Default Value: N
|
| 34 |
GM_501_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Have 501(c)(3) status
Y/N Table Edit
Default Value: N
|
| 35 |
AFFILIATE_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Affiliate
Y/N Table Edit
Default Value: N
|
| 36 |
GM_FULL_TIME_EE |
Character(3) |
VARCHAR2(3) NOT NULL |
Full-time equivalent employees
A=3 or fewer
B=4-5
C=6-14
D=15-50
E=51-100
F=Over 100
Default Value: A
|
| 37 |
GM_ANNL_BUDGET |
Character(3) |
VARCHAR2(3) NOT NULL |
Size of the annual budget
A=Less Than $150,000
B=$150,000 - $299,999
C=$300,000 - $499,999
D=$500,000 - $999,999
E=$1,000,000 - $4,999,999
F=$5,000,000 or more
Default Value: A
|