CS_BIND_MAP_VW2

(SQL View)
 Index Back

Rule Drill Down Bind Mapping

02/20/07 SCC F-AHAYT-X0ES6 View showing bind mapping. Used to display record.field and level information on Rule Drill down.

SELECT A.CS_SOURCE_TRANS , A.CS_BIND_VAR , A.CS_BIND_RECNAME , A.FIELDNAME , A.CS_DISPLAYTYPE , A.CS_FIELD_TYPE , C.CS_LEVEL FROM PS_CS_BIND_MAP_DTL A , PS_CS_BIND_MAP B , PS_CS_SRC_STRUCT C WHERE A.CS_SOURCE_TRANS=B.CS_SOURCE_TRANS AND A.CS_BIND_RECNAME=B.CS_BIND_RECNAME AND B.CS_SOURCE_TRANS=C.CS_SOURCE_TRANS AND B.CS_SRC_RECNAME=C.CS_SRC_RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CS_SOURCE_TRANS Character(2) VARCHAR2(2) NOT NULL Source Transaction 03/22/07 cel F-AHAYT-748L7: Added Purchase Order (03) as a new source transaction 01/12/11 tbg SCMT-92-MDEM-04: Added RFx (04) as new source transaction for strat sourcing (doc authoring)
01=Ad Hoc
02=Purchasing Contracts
03=Purchase Orders
04=Sourcing Events
97=All Sources
98=Multiple Sources
99=Not Transactional
2 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable

Prompt Table: CS_BINDS_VW3

3 CS_BIND_RECNAME Character(15) VARCHAR2(15) NOT NULL Binds Recordname
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: CS_BINDFLD_VW

5 CS_DISPLAYTYPE Character(1) VARCHAR2(1) NOT NULL Display Type
1=Xlat Long Name
2=Xlat Short Name
3=Xlat Value
6 CS_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Bind Variable Field Type 5/11/07 F-AHAYT-X0ES6 - Added new field type of Prompt
1=String
3=Date
4=Date/Time
5=Yes/No
6=Integer
7=Decimal
8=Prompt Table
9=Checkbox
7 CS_LEVEL Number(2,0) SMALLINT NOT NULL Level