GPES_RC_TRGCLNU

(SQL Table)
Index Back

Trigger cleanup run control

Trigger clean up run contorl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
5 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP

7 GPES_DELETE_OPTN Character(1) VARCHAR2(1) NOT NULL Trigger clean up options
A=Clean active
C=Delete cancelled
D=Delete marked for deletion
M=Mark for deletion

Default Value: M