GPES_ST_REC_VW

(SQL View)
Index Back

Trigger Setup-Record

Trigger setup information for the record level.

SELECT DISTINCT COUNTRY , RECNAME , TRGR_LVL_OPTN , TRGR_EFFDT_TYPE , TRGR_ACTIVE_IND FROM PS_GP_TRGR_REC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY_VW

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

Prompt Table: PSRECDEFN_VW

3 TRGR_LVL_OPTN Character(1) VARCHAR2(1) NOT NULL Trigger Level
F=Field
R=Record

Default Value: R

4 TRGR_EFFDT_TYPE Character(1) VARCHAR2(1) NOT NULL Trigger Effdt Type
B=Begin-End Date
E=Effective Date
F=Fixed Date

Default Value: E

5 TRGR_ACTIVE_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether trigger definition is active.
N=Trigger Inactive
Y=Trigger Active

Default Value: Y