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 |