TL_TIMEDAT_RCTL

(SQL Table)
Index Back

Reported Time Pub Run Control

Reported Time Publsih Run Control record .

# 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 START_DATE Date(10) DATE Start Date for Gen Standing PO
4 END_DATE Date(10) DATE End Date
5 SELECT_EMPLOYEE Character(1) VARCHAR2(1) NOT NULL Select Employee

Y/N Table Edit

Default Value: N

6 TL_TIME_OPTION Character(1) VARCHAR2(1) NOT NULL Time Option
1=Current Date
2=Start Date and End Date

Default Value: 2

7 RPTD_TIME_IND Character(1) VARCHAR2(1) NOT NULL Reported Timed Ind
N=No
X=Adjacent Period Punches
Y=Yes
8 LEAVE_BAL_IND Character(1) VARCHAR2(1) NOT NULL Leave Balance indicator
9 PAYABLE_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether Payable Time exists (for EE on Day)
10 TL_VERIFY_PRESENCE Character(1) VARCHAR2(1) NOT NULL Verify Presence indicator
11 TL_DAY_NUM10 Number(2,0) SMALLINT NOT NULL View Detail for Day

Default Value: 0

12 TL_DAY_NUM20 Number(2,0) SMALLINT NOT NULL View Detail for Day

Default Value: 0

13 LIST_ID Character(12) VARCHAR2(12) NOT NULL List ID

Prompt Table: TL_VAL_LIST_VW1
Set Control Field: LIST_ID