STDNT_RFND_VW(SQL View) |
Index Back |
|---|---|
Refund Header ViewThis view is used as a prompt form Refund Number in COMM_VAR_DATA. Emplid is the primary key. |
| SELECT B.COMMON_ID ,A.EMPLID ,A.BUSINESS_UNIT ,A.REFUND_NBR ,B.ITEM_TERM ,A.REFUND_STATUS ,A.REFUND_METHODE ,C.REFUND_FORMAT ,A.ADDRESS_TYPE ,A.REFUND_DTTM ,A.VOUCHER_ID ,A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.PAGE_NUM ,A.BATCH_ID ,B.ITEM_AMT ,A.REFUND_AMT ,A.CURRENCY_CD ,A.REFUND_TYPE FROM PS_REFUND_HDR A , PS_ITEM_SF B , PS_REFUND_DTL C WHERE B.SA_ID_TYPE = 'P' AND A.REFUND_STATUS IN ('A','B','P','C','D','P','S','V') AND A.EMPLID = B.COMMON_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REFUND_NBR = B.REFUND_NBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.REFUND_NBR = C.REFUND_NBR AND C.LINE_SEQ_NBR = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMMON_ID | Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 2 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | REFUND_NBR |
Number(12,0) | DECIMAL(12) NOT NULL | Refund Nbr |
| 5 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
| 6 | REFUND_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Refund Status
A=AP Interface Created B=Credit Pending C=Confirmed D=Credit Declined E=Entered I=Interfaced to Payroll P=Posted R=Reversed S=Paysheet Created V=Sent to ePayment Servicer X=Cancelled |
| 7 | REFUND_METHODE | Character(1) | VARCHAR2(1) NOT NULL |
Refund Method
A=Accounts Payable O=Other P=Payroll |
| 8 | REFUND_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Refund Format
A=Automatic Check C=Credit Card D=Direct Deposit E=Electronic Check P=Paper Check |
| 9 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: HCR_ADDR_TYP_I |
| 10 | REFUND_DTTM | DateTime(26) | TIMESTAMP | Refund Date and Time |
| 11 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 12 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 13 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 14 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 15 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
| 16 | BATCH_ID | Character(12) | VARCHAR2(12) NOT NULL | Batch ID |
| 17 | ITEM_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Item Amount |
| 18 | REFUND_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Refund Amount |
| 19 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 20 | REFUND_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Refund Type
C=Combined F=Financial Aid N=Non Financial O=On-Line Request |