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

CCR_DUNS_VW

(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.LEGAL_BUS_NAME , A.FULLNAME FROM PS_CCR_VNDR_HDR A 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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DUNS_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
2	LEGAL_BUS_NAME	Character(120)	VARCHAR2(120) NOT NULL	Business Name
3	FULLNAME	Character(60)	VARCHAR2(60) NOT NULL	Full name