BI_FSS_MATCH_VW

(SQL View)
 Index Back

Financial Sanction Match

Financial Sanction Match

SELECT A.BUSINESS_UNIT , A.INVOICE , A.LINE_SEQ_NUM , A.ADDR_TYPE_ID , %subrec(SDN_HITS_SREC,A) , A.OFAC_STATUS , A.SDN_PUBLISH_DATE , A.FSS_ACTIVITY_DT , A.FSS_USER_OVR , A.CUST_SETID , A.CUST_ID , A.ADDRESS_SEQ_NUM , A.EFFDT , A.NAME1 , A.NAME2 , A.NAME3 , %subrec(ADDRESS_SBR,A) , A.REASON_TYPE , A.REASON_CD , A.PROCESS_NAME , A.PROCESS_INSTANCE , A.OPRID , A.ADD_DTTM , A.LAST_UPDATE_DTTM FROM PS_BI_FSS_MATCH A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 ADDR_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Address Type Identifier for Billing. Translates start with 1 represent header level, 2 represent line level.
100=Header Bill To Address
101=Header Ship To Address
102=Header Sold To Address
103=Header Service To Address
104=Header Courtesy Copy Address
105=Header Credit Card Address
200=Line Ship To Address
201=Line Sold To Address
202=Line Service To Address
203=Line Tax Ship To Address
301=Attached Bill Address
5 SDN_ID Number(15,0) DECIMAL(15) NOT NULL Unique Identifier for a loaded Financial Sanction list.
6 SDN_ENTRY_ID Number(15,0) DECIMAL(15) NOT NULL Unique identifier for an Financial Sanction entry.
7 SDN_LIST_TYPE Character(4) VARCHAR2(4) NOT NULL Types of lists that can be loaded into the system.
ESDN=Enterprise SDN
EU=EU
OFAC=OFAC
8 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
9 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
10 SDN_PUBLISH_DATE Date(10) DATE Publish date given on the loaded Financial Sanction list.
11 FSS_ACTIVITY_DT Date(10) DATE EGS 03/02/06: Created
12 FSS_USER_OVR Character(1) VARCHAR2(1) NOT NULL User Override
A=Customer Name has Overriden
N=No Customer Information Change
Y=Customer Information Changed
13 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
14 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.
15 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number
16 EFFDT Date(10) DATE Effective Date

Default Value: %date

17 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
18 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
19 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

21 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
22 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
23 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
24 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
25 CITY Character(30) VARCHAR2(30) NOT NULL City
26 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
27 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
28 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
29 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
30 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
31 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
32 COUNTY Character(30) VARCHAR2(30) NOT NULL County
33 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

34 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
35 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
36 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

37 REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Reason Type
38 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
39 PROCESS_NAME Character(12) VARCHAR2(12) NOT NULL Process Name
40 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
41 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
42 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
43 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.