PROCESS_INSTANCE1=Current Date
2=Start Date and End Date
N=No
X=Adjacent Period Punches
Y=Yes
Default Value: 0
Default Value: 0
Prompt Table:
TL_VAL_LIST_VW1
Set Control Field: LIST_ID
TL_TIMEDAT_AET(SQL Table) |
Index Back |
|---|---|
Reported Time OWSUsed in publishing the Reported Time |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 5 | END_DATE | Date(10) | DATE | End Date |
| 6 | SELECT_EMPLOYEE | Character(1) | VARCHAR2(1) NOT NULL | Select Employee |
| 7 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 8 | TL_TIME_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Time Option
1=Current Date 2=Start Date and End Date |
| 9 | TL_VERIFY_PRESENCE | Character(1) | VARCHAR2(1) NOT NULL | Verify Presence indicator |
| 10 | RPTD_TIME_IND | Character(1) | VARCHAR2(1) NOT NULL |
Reported Timed Ind
N=No X=Adjacent Period Punches Y=Yes |
| 11 | LEAVE_BAL_IND | Character(1) | VARCHAR2(1) NOT NULL | Leave Balance indicator |
| 12 | PAYABLE_IND | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Payable Time exists (for EE on Day) |
| 13 | TL_DAY_NUM10 | Number(2,0) | SMALLINT NOT NULL |
View Detail for Day
Default Value: 0 |
| 14 | TL_DAY_NUM20 | Number(2,0) | SMALLINT NOT NULL |
View Detail for Day
Default Value: 0 |
| 15 | LIST_ID | Character(12) | VARCHAR2(12) NOT NULL |
List ID
Prompt Table:
TL_VAL_LIST_VW1
|