GM_X_SUP_A_VW(SQL View) |
Index Back |
|---|---|
Grants EDI Other Sup Active |
| SELECT DISTINCT O.BUSINESS_UNIT , O.PROPOSAL_ID , O.VERSION_ID , A.EMPLID , A.BUSINESS_UNIT_PROP , A.CONTRACT_NUM , B.REF_AWD_NUMBER , A.PROJECT_ID , A.EMPLID_RELATED , B.NAME , B.TITLE56 , B.DESCR254 , B.CUST_ID , C.NAME1 , A.TOTAL_AWARD_AMT , B.BEGIN_DT , B.END_DT , A.PERCENTAGE , B.AWARD_STATUS , A.VERSION_ID , %Round(%DecDiv(%decmult(A.APPT_TYPE_MTH_CAL, A.PERCENTAGE),100),2) , %Round(%DecDiv(%decmult(A.APPT_TYPE_MTH_ACAD, A.PERCENTAGE),100),2) , %Round(%DecDiv(%decmult(A.APPT_TYPE_MTH_SUMR, A.PERCENTAGE),100),2) , O.ROLE_TYPE FROM PS_GM_AWD_BUDP_VW A , PS_GM_AWARD B , PS_GM_PROP_PROF_OA O , PS_CUSTOMER C WHERE A.BUSINESS_UNIT_PROP=O.BUSINESS_UNIT_PROP AND A.CONTRACT_NUM=O.CONTRACT_NUM AND A.PROJECT_ID=O.PROJECT_ID AND A.EMPLID=O.EMPLID AND B.BUSINESS_UNIT=A.BUSINESS_UNIT_PROP AND B.CONTRACT_NUM=A.CONTRACT_NUM AND C.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC H WHERE H.SETCNTRLVALUE = B.BUSINESS_UNIT AND H.RECNAME = 'CUSTOMER') AND C.CUST_ID = B.CUST_ID AND C.CUST_STATUS = '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_TO |
Character(7) | VARCHAR2(7) NOT NULL | Version ID To |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | BUSINESS_UNIT_PROP |
Character(5) | VARCHAR2(5) NOT NULL | Proposal Business Unit |
| 6 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 7 | REF_AWD_NUMBER | Character(25) | VARCHAR2(25) NOT NULL | Reference Award Number |
| 8 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 9 | EMPLID_RELATED | Character(11) | VARCHAR2(11) NOT NULL | Related People ID |
| 10 | NAME |
Character(50) | VARCHAR2(50) NOT NULL | Name |
| 11 | TITLE56 | Character(56) | VARCHAR2(56) NOT NULL | TITLE56 |
| 12 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 13 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 14 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 15 | TOTAL_AWARD_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Award Amount |
| 16 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 17 | END_DT | Date(10) | DATE | End Date |
| 18 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
| 19 | PROPOSAL_STATUS_GR | Character(4) | VARCHAR2(4) NOT NULL |
PROPOSAL_STATUS_GR
ACP=Accepted Award APR=Institution Approved AWD=Awarded AWP=Award Pending DEC=Declined by Sponsor DIS=Discontinued DRF=Draft NOT=Not Funded PEF=Pending Funding PEN=Pending Approval REF=Refused by Institution REJ=Rejected SUBM=Submitted WIT=Withdrawn |
| 20 | VERSION_ID |
Character(7) | VARCHAR2(7) NOT NULL | Version ID |
| 21 | APPT_TYPE_MTH_CAL | Number(6,2) | DECIMAL(5,2) NOT NULL | Calendar Appointment Months |
| 22 | APPT_TYPE_MTH_ACAD | Number(6,2) | DECIMAL(5,2) NOT NULL | Academic Appointment Months |
| 23 | APPT_TYPE_MTH_SUMR | Number(6,2) | DECIMAL(5,2) NOT NULL | Summer Appointment Months |
| 24 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |