EMPLIDINSTITUTION_SETPrompt Table: ITEM_TYPE_BU_VW
SSF_ISETPMT_VW(SQL View) |
Index Back |
|---|---|
Self Service Payment Items |
| SELECT A.COMMON_ID ,G.INSTITUTION_SET ,A.BUSINESS_UNIT ,A.ITEM_TERM ,A.PAYMENT_ID_NBR ,P.POSTED_DATE ,A.ITEM_TYPE ,SUM(A.ITEM_AMT) ,SUM(A.ITEM_BALANCE) ,A.CURRENCY_CD FROM PS_ITEM_SF A , PS_ISET_BU_DTL G , PS_PAYMENT_TBL P WHERE A.SA_ID_TYPE = 'P' AND A.BUSINESS_UNIT = G.BUSINESS_UNIT AND A.COMMON_ID = P.COMMON_ID AND A.BUSINESS_UNIT = P.BUSINESS_UNIT AND A.SA_ID_TYPE = P.SA_ID_TYPE AND A.PAYMENT_ID_NBR = P.PAYMENT_ID_NBR AND A.ITEM_TYPE_CD IN ('P','D') AND P.CONTRACT_NUM = ' ' GROUP BY A.COMMON_ID ,G.INSTITUTION_SET ,A.BUSINESS_UNIT ,A.ITEM_TERM ,A.PAYMENT_ID_NBR ,P.POSTED_DATE ,A.ITEM_TYPE,A.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION_SET |
Character(5) | VARCHAR2(5) NOT NULL | Institution Set |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 5 | PAYMENT_ID_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Payment ID Nbr |
| 6 | POSTED_DATE | Date(10) | DATE | Date Posted |
| 7 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: ITEM_TYPE_BU_VW |
| 8 | SSF_AMOUNT | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Amount |
| 9 | SSF_BALANCE | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Balance |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |