TL_AE_DC_RNCTL

(SQL Table)
Index Back

TL Auto Enrollment Runctl

This record is used to define the Time and Labor Run Control.

# 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 FROMDATE Date(10) DATE NOT NULL From Date
4 THRUDATE Date(10) DATE NOT NULL End Date
5 TL_RUN_OPTIONS Character(1) VARCHAR2(1) NOT NULL T&L Auto enrollment feature - Run control field options
A=All Employees
Q=Process Group Query
S=Select Employees

Default Value: S

6 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name

Prompt Table: TL_QRYNAME_VW