Prompt Table: SP_BU_PC_NONVW
CONTRACT_NUMPrompt Table: GM_AWARD
SEQ_NUMEMPLIDPrompt Table: GM_ELIG_PI_VW
DEPTIDPrompt Table: GM_DEPT_TBL_VW
GM_AWD_ALL_PCT(SQL Table) |
Index Back |
|---|---|
Proposal Allocation PercentageThis record allows for multiple Allocation Percentages per a proposal. The sum of Allocated Percentages for all members should be 100 Percent. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: GM_AWARD |
| 3 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GM_ELIG_PI_VW |
| 5 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: GM_DEPT_TBL_VW |
| 6 | PERCENTAGE_OWNED | Number(3,0) | SMALLINT NOT NULL | Percentage Minority Owned |