GM_AWD_ATTACH(SQL Table) |
Index Back |
|---|---|
Award Attachments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Award ID |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: GM_AWARD.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | MILESTONE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
Prompt Table: GM_MLS_SRCH_VW |
| 6 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 7 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: GM_AWD_PRJ_VW2 |
| 8 | CERT_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Certification Code
Prompt Table: GM_SRCH_CERT_VW |
| 9 | BUDGET_PERIOD_GM | Number(3,0) | SMALLINT NOT NULL |
BUDGET_PERIOD_GM
Prompt Table: GM_AWD_BUDPD_VW |
| 10 | PERIOD | Number(3,0) | SMALLINT NOT NULL |
Period
Prompt Table: GM_AWDMOD_PD_VW |
| 11 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Prompt Table: GM_AWDMODSEQ_VW |
| 12 | COMMENTS | Long Character | CLOB | Comment |
| 13 | GM_ATT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Grants Attachment Type
A=Award Modifications C=Certifications F=Funding Period G=General M=Milestones Default Value: G |
| 14 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
| 15 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 16 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 17 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |