TL_TIMEDAT_RCTL(SQL Table) |
Index Back |
---|---|
Reported Time Pub Run ControlReported 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
|