GM_PROP_FLG_VW(SQL View) |
Index Back |
|---|---|
Flags used for Pre-To-Post |
| SELECT A.BUSINESS_UNIT ,A.PROPOSAL_ID ,A.VERSION_ID ,A.PROPOSAL_FLG ,A.PPSL_TO_CNTRCT_FLG ,A.CONTRACT_NUM ,A.BILL_COST_BUD_FLG ,A.BILL_COST_RT_FLG ,A.BEGIN_DT ,A.END_DT ,A.LAST_VERSION_ID ,A.CURRENCY_CD ,A.RT_TYPE ,A.SCEN_ADJUST_PCT_EX ,A.SCEN_ADJUST_PCT_TM ,A.HOURS_OPTION ,A.DUE_DT ,A.GM_CERT_LVL ,A.GM_COMP_LVL ,A.GM_DEPT_CR_LVL ,A.GM_PROF_CR_LVL ,A.GM_RSRC_LVL ,A.GM_VNDR_LVL FROM PS_GM_PROPOSAL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROPOSAL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Proposal ID |
| 3 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 4 | PROPOSAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Proposal Checkbox
G=Grants Proposal I=Internal Proposal S=Solicitation Proposal |
| 5 | PPSL_TO_CNTRCT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Proposal To Contract
D=Contract Generated N=Not Generated P=Pre-Sales Spending |
| 6 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 7 | BILL_COST_BUD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Budget Options
A=Bill and Cost Rows B=Bill Rows C=Cost Rows N=None |
| 8 | BILL_COST_RT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Create Rate Options
A=Bill and Cost Rows B=Bill Rows C=Cost Rows |
| 9 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 10 | END_DT | Date(10) | DATE | End Date |
| 11 | LAST_VERSION_ID | Character(4) | VARCHAR2(4) NOT NULL | Last Version ID |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 14 | SCEN_ADJUST_PCT_EX | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Scenario Adjustment % for Expense 06/09/2004 PR_FS_B005 Added Label NON_LABOR_ADJUST |
| 15 | SCEN_ADJUST_PCT_TM | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Scenario Adjustment % for Time 06/09/2004 PR_FS_B005 Added Label - LABOR_ADJUST |
| 16 | HOURS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Hours Option
D=Start/End Date I=Hours W=Weeks |
| 17 | DUE_DT | Date(10) | DATE | Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received. |
| 18 | GM_CERT_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Certifications Level
A=Primary Project P=All Projects |
| 19 | GM_COMP_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Components Level
A=Primary Project P=All Projects |
| 20 | GM_DEPT_CR_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Departmentl Credits Level
A=Primary Project P=All Projects |
| 21 | GM_PROF_CR_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Professional Credits Level
A=Primary Project P=All Projects |
| 22 | GM_RSRC_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Resources Level
A=Primary Project P=All Projects |
| 23 | GM_VNDR_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Subrecipients Level
A=Primary Project P=All Projects |