BI_HDR_LATE_VW (SQL View)	Index Back
Late Fees Bill Hdr View View used by Late Fees to identify Bill Request Nbr to use.

BI_HDR_LATE_VW

(SQL View)

Late Fees Bill Hdr View

View used by Late Fees to identify Bill Request Nbr to use.

SELECT DISTINCT A.BUSINESS_UNIT ,A.BI_REQ_NBR ,A.INVOICE_DT ,A.BILL_REQ_ID ,A.TYPE_OF_REQUEST ,B.BILL_DATE_TIME ,A.BI_REQ_DT_TM ,B.DUE_DT FROM PS_BI_REQUEST A , PS_BI_BILL_HEADER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BI_REQ_NBR = B.BI_REQ_NBR AND B.SF_BILL_STATUS = 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 BI_REQ_NBR Number(10,0) DECIMAL(10) NOT NULL Billing Request Nbr

3 INVOICE_DT Date(10) DATE Invoice Date

4 BILL_REQ_ID Character(10) VARCHAR2(10) NOT NULL Bill Request ID

5 TYPE_OF_REQUEST Character(1) VARCHAR2(1) NOT NULL Type of Request
C=Organization
E=Student

6 BILL_DATE_TIME DateTime(26) TIMESTAMP Bill Date and Time

7 BI_REQ_DT_TM DateTime(26) TIMESTAMP Billing Request Dt/Time

8 DUE_DT Date(10) DATE Expected Birth Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	BI_REQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Billing Request Nbr
3	INVOICE_DT	Date(10)	DATE	Invoice Date
4	BILL_REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Bill Request ID
5	TYPE_OF_REQUEST	Character(1)	VARCHAR2(1) NOT NULL	Type of Request C=Organization E=Student
6	BILL_DATE_TIME	DateTime(26)	TIMESTAMP	Bill Date and Time
7	BI_REQ_DT_TM	DateTime(26)	TIMESTAMP	Billing Request Dt/Time
8	DUE_DT	Date(10)	DATE	Expected Birth Date