USF_HIERARCH_VW

(SQL View)
 Index Back

SAM / D&B Hierarchy

cmh 11/26/2013 -- removed USF_AGY_PAR_DODAAC SELECT A.DUNS_NUMBER , A.USF_DUNS_PLUS4 , A.USF_ADDR_TYPE , A.USF_DODAAC , 'DNB' , A.USF_PARENT_DUNS --, B.USF_DODAAC , A.USF_ADDR_TYPE FROM PS_USF_VNDR_ADDR A LEFT OUTER JOIN PS_USF_VNDR_HDR B ON B.DUNS_NUMBER = A.USF_PARENT_DUNS WHERE A.USF_ADDR_TYPE IN ('DM', 'GL', 'HQ')

SELECT A.USF_UEID , A.USF_EFT_IND , A.USF_ADDR_TYPE , A.DUNS_NUMBER , A.USF_DODAAC , 'DNB' , A.USF_PARENT_DUNS , A.USF_ADDR_TYPE , A.USF_PARENT_UEID , A.USF_DUNS_PLUS4 FROM PS_USF_VNDR_ADDR A WHERE A.USF_ADDR_TYPE IN ('IP', 'HQP','UDP', 'UP')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 USF_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity Identifier
2 USF_EFT_IND Character(4) VARCHAR2(4) NOT NULL Entity EFT Indicator
3 USF_ADDR_TYPE Character(3) VARCHAR2(3) NOT NULL Address Type
4 DUNS_NUMBER Character(9) VARCHAR2(9) NOT NULL DUNS Number
5 USF_DODAAC Character(9) VARCHAR2(9) NOT NULL Department of Defense Activity Address Code
6 USF_HIERARCHY_TYPE Character(4) VARCHAR2(4) NOT NULL Hierarchy Type
DNB=Dun & Bradstreet Corporation
SAM=System for Award Management
7 USF_PARENT_DUNS Character(13) VARCHAR2(13) NOT NULL Parent DUNS
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 USF_PARENT_UEID Character(12) VARCHAR2(12) NOT NULL Unique Entity ID Parent
10 USF_DUNS_PLUS4 Character(4) VARCHAR2(4) NOT NULL DUNS Suffix