TL_AE_SCTION_VW (SQL View)	Index Back
AE Section View A View of User Defined AE Sections.

TL_AE_SCTION_VW

(SQL View)

AE Section View

A View of User Defined AE Sections.

SELECT AE_SECTION FROM PS_TL_AE_SECTION WHERE PROCESS_TYPE = 'R' AND AE_APPLID = 'TL_TA_RULES' UNION SELECT AE_SECTION FROM PSAESECTDEFN WHERE AE_APPLID = 'TL_TA_RULES' AND NOT EXISTS ( SELECT 'X' FROM PS_TL_RULE_DEFN WHERE AE_SECTION = PSAESECTDEFN.AE_SECTION AND TL_USER_EXIT = 'N')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AE_SECTION_UD Character(8) VARCHAR2(8) NOT NULL User defined AE Section Name. This is an AE Section that a user has previously written to handle a specific rule that could not be defined using one of the delivered Rule Templates or Rule Components (Actions, Conditions, SQL Objects). The AE Section must be populated on the PS_TL_AE_SECTION table.