AP_ASSTN_DTL

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSTN_NAME Character(30) VARCHAR2(30) NOT NULL Association Name
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
3 AP_STEP_TYPE Character(3) VARCHAR2(3) NOT NULL Step Type
FIN=Final
FST=First
INT=Intermediate
4 SOURCE_OBJECT Character(10) VARCHAR2(10) NOT NULL Source Object

Prompt Table: AP_MTCH_OBJECT

5 ASSOCIATION_OBJECT Character(10) VARCHAR2(10) NOT NULL Associated Object

Prompt Table: AP_MTCH_OBJECT

6 DRIVER_REC_NAME Character(15) VARCHAR2(15) NOT NULL Driver Record Name

Prompt Table: PSRECDEFN_VW2

7 INTERMED_OBJECT Character(10) VARCHAR2(10) NOT NULL Intermediate Object

Prompt Table: AP_MTCH_OBJECT

8 INTER_REC_NAME Character(15) VARCHAR2(15) NOT NULL Intermediate Record Name

Prompt Table: PSRECDEFN_VW2

9 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: SQLID_VW

    • 10 FIELD_CRIT_SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier
    11 OUTPUT_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: PSRECDEFN_VW2

    12 FIELD_MAP_SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier