DB_REPORTS (SQL Table)	Index Back
Duns Reports Duns Reports

DB_REPORTS

(SQL Table)

Duns Reports

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 DB_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number

3 DB_PRODUCT Character(4) VARCHAR2(4) NOT NULL DB Productsname
BUVR=Business Verification
CRSC=Credit Score(USA)
DESQ=Delinquency Score
DSSP=Decision Support
ENMG=Enterprise Management
FNCL=Financials
FNST=Financial Standing
FTBA=Family Tree - Basic
FTEN=Family Tree - Enhanced
GDM=GDM
GDMP=GDM PLUS
GLFS=Global Failure Risk Score
MKID=WorldBase Marketing ID
MKLK=WorldBase Marketing Plus Link
MKPL=WorldBase Marketing Plus
QKCK=Quick Check
VNDR=Supplier Management

4 EFFDT Date(10) DATE Effective Date
Default Value: %date

5 DB_PRODUCT_TXT Long Character CLOB Report Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DB_NUMBER	Character(9)	VARCHAR2(9) NOT NULL	DUNS Number
3	DB_PRODUCT	Character(4)	VARCHAR2(4) NOT NULL	DB Productsname BUVR=Business Verification CRSC=Credit Score(USA) DESQ=Delinquency Score DSSP=Decision Support ENMG=Enterprise Management FNCL=Financials FNST=Financial Standing FTBA=Family Tree - Basic FTEN=Family Tree - Enhanced GDM=GDM GDMP=GDM PLUS GLFS=Global Failure Risk Score MKID=WorldBase Marketing ID MKLK=WorldBase Marketing Plus Link MKPL=WorldBase Marketing Plus QKCK=Quick Check VNDR=Supplier Management
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	DB_PRODUCT_TXT	Long Character	CLOB	Report Text