UPG_GM(SQL Table) |
Index Back |
|---|---|
For upgrade from 84/88 to 89Upgrade only |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CA.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 2 | GM_CERT_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Certifications Level
A=Primary Project P=All Projects Default Value: P |
| 3 | GM_PROF_CR_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Professional Credits Level
A=Primary Project P=All Projects Default Value: P |
| 4 | GM_DEPT_CR_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Departmentl Credits Level
A=Primary Project P=All Projects Default Value: P |
| 5 | GM_COMP_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Components Level
A=Primary Project P=All Projects Default Value: A |
| 6 | GM_RSRC_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Resources Level
A=Primary Project P=All Projects Default Value: P |
| 7 | GM_VNDR_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Subrecipients Level
A=Primary Project P=All Projects Default Value: P |