UPG_GM_DEFAULTS

(SQL Table)
Index Back

Grants Upgrade to 89 Table

This Table should be populated by the Customer before the Upgrade to 89. The values entered in this page will be used to populate the GM_BU_AWD_SETUP and GM_PROPOSAL tables.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GM_CERT_LVL Character(1) VARCHAR2(1) NOT NULL Certifications Level
A=Primary Project
P=All Projects

Default Value: P

2 GM_PROF_CR_LVL Character(1) VARCHAR2(1) NOT NULL Professional Credits Level
A=Primary Project
P=All Projects

Default Value: P

3 GM_DEPT_CR_LVL Character(1) VARCHAR2(1) NOT NULL Departmentl Credits Level
A=Primary Project
P=All Projects

Default Value: P

4 GM_COMP_LVL Character(1) VARCHAR2(1) NOT NULL Components Level
A=Primary Project
P=All Projects

Default Value: A

5 GM_RSRC_LVL Character(1) VARCHAR2(1) NOT NULL Resources Level
A=Primary Project
P=All Projects

Default Value: P

6 GM_VNDR_LVL Character(1) VARCHAR2(1) NOT NULL Subrecipients Level
A=Primary Project
P=All Projects

Default Value: P