FEDREG_SEARCH (SQL View)	Index Back
FedReg Search Vw Date Init. Issue # Description 051208 JJM AP-91-TLT-0001 FSIO Fed Reg Interface

FEDREG_SEARCH

(SQL View)

FedReg Search Vw

Date Init. Issue # Description 051208 JJM AP-91-TLT-0001 FSIO Fed Reg Interface

SELECT DISTINCT A.DUNS_NUMBER , A.CCR_DUNS_PLUS4 , A.SOURCE_SYSTEM , A.LEGAL_BUS_NAME , A.FULLNAME , A.EIN_NUMBER , B.CUSTOMER_SETID , B.CUST_ID , C.SETID , C.VENDOR_ID FROM PS_CCR_VNDR_HDR A LEFT OUTER JOIN PS_CCR_CUST_XREF B ON A.DUNS_NUMBER = B.DUNS_NUMBER AND A.CCR_DUNS_PLUS4 = B.CCR_DUNS_PLUS4 LEFT OUTER JOIN PS_CCR_VNDR_XREF C ON A.DUNS_NUMBER = C.DUNS_NUMBER AND A.CCR_DUNS_PLUS4 = C.CCR_DUNS_PLUS4 WHERE A.SOURCE_SYSTEM = 'FED'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
Prompt Table: CCR_DUNS_VW

2 CCR_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix
Prompt Table: CCR_PLUS4_VW

3 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer

4 LEGAL_BUS_NAME Character(120) VARCHAR2(120) NOT NULL Business Name

5 FULLNAME Character(60) VARCHAR2(60) NOT NULL Full name

6 EIN_NUMBER Character(9) VARCHAR2(9) NOT NULL Employer Identification Number

7 CUSTOMER_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
Prompt Table: SP_SETID_NONVW

8 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

9 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
Prompt Table: SP_SETID_NONVW

10 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number Prompt Table: CCR_DUNS_VW
2	CCR_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix Prompt Table: CCR_PLUS4_VW
3	SOURCE_SYSTEM	Character(3)	VARCHAR2(3) NOT NULL	Source System CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer
4	LEGAL_BUS_NAME	Character(120)	VARCHAR2(120) NOT NULL	Business Name
5	FULLNAME	Character(60)	VARCHAR2(60) NOT NULL	Full name
6	EIN_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	Employer Identification Number
7	CUSTOMER_SETID	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID Prompt Table: SP_SETID_NONVW
8	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
9	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID Prompt Table: SP_SETID_NONVW
10	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier