BI_AUTH_EF_VW (SQL View)	Index Back
Billing Authority Eff Vw This View should be used when ever prompting for the billing authority from an effective dated table. Example : CUST_OPTION is an effective dated table. Use this view to prompt for BILLING_AUTHORITY

BI_AUTH_EF_VW

(SQL View)

Billing Authority Eff Vw

This View should be used when ever prompting for the billing authority from an effective dated table. Example : CUST_OPTION is an effective dated table. Use this view to prompt for BILLING_AUTHORITY

SELECT s.setid , s.billing_specialist , s.name1 , s.phone FROM PS_BI_SPECIALIST s WHERE s.effdt = ( SELECT MAX(effdt) FROM PS_BI_SPECIALIST WHERE setid = s.setid AND billing_specialist = s.billing_specialist AND effdt <= %CurrentDateIn) AND S.EFF_STATUS = 'A' AND s.bill_authority_flg = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID2_NONVW

2 BILLING_AUTHORITY Character(8) VARCHAR2(8) NOT NULL Billing Authority
Prompt Table: BI_SPECIALIST

3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1

4 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID2_NONVW
2	BILLING_AUTHORITY	Character(8)	VARCHAR2(8) NOT NULL	Billing Authority Prompt Table: BI_SPECIALIST
3	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
4	PHONE	Character(24)	VARCHAR2(24) NOT NULL	Telephone