SAC_MAP_DEFN

(SQL Table)
 Index Back

XML Mapper Map Definition

XML Mapper Map Defintion

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MAP_ID Character(40) VARCHAR2(40) NOT NULL Transformation Map ID
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 MAPTRANSTYPE Character(2) VARCHAR2(2) NOT NULL XML Mapper Translate Type
AP=Application Class
AT=Attribute Value
FD=Field Alias
RE=Record Alias
SQ=Field Value - SQL
ST=Field Value
VO=Values Only
XS=XSL

Default Value: ST

4 SAC_XSL_CRITERIA Character(1) VARCHAR2(1) NOT NULL XML Mapper XSL criteria flag
N=None
R=Record/Field
X=XPath

Default Value: N

5 SAC_XSL_XPATH Character(254) VARCHAR2(254) NOT NULL XML Mapper XSL XPath condition
6 MSG_APPLIED Character(1) VARCHAR2(1) NOT NULL Message Applied
A=All Messages
S=Specific Message

Default Value: A

7 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

Prompt Table: PSMSGDEFN

8 REC_APPLIED Character(1) VARCHAR2(1) NOT NULL Record Applied
A=All Records
S=Specific Record

Default Value: A

9 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: %EDITTABLE

10 FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Field Name

Prompt Table: %EDITTABLE2

11 SAC_XSL_AREA Long Character CLOB XML Mapper XSL Long text area.
12 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID

Prompt Table: PSAPPCLASSDEFN

13 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
14 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)

    Prompt Table: SAC_SQL_VW

    • 15 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive

    Default Value: A