AP_ASCALG_VW1

(SQL View)
Index Back

Assoc Algorithm Driver Fields


SELECT A.STEP_NAME , A.ALGTHM_FLDSRC , A.ALGTHM_FLDTYPE , A.FIELDNAME FROM PS_AP_ASSTN_ALGFLD A WHERE A.ALGTHM_FLDSRC = 'D'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STEP_NAME Character(40) VARCHAR2(40) NOT NULL Step Name
2 ALGTHM_FLDSRC Character(1) VARCHAR2(1) NOT NULL Algorithm Field Source
A=Association Record
D=Driver Record

Default Value: D

3 ALGTHM_FLDTYPE Character(1) VARCHAR2(1) NOT NULL Algorithm Field Type
O=Order By Field
R=Rule Field
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: AP_ASC_DREC_VW