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

CCR_PLUS4_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.CCR_DUNS_PLUS4 , 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 CCR_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix

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

4 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	CCR_DUNS_PLUS4	Character(4)	VARCHAR2(4) NOT NULL	DUNS Suffix
3	LEGAL_BUS_NAME	Character(120)	VARCHAR2(120) NOT NULL	Business Name
4	FULLNAME	Character(60)	VARCHAR2(60) NOT NULL	Full name