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 |