TL_MASS_SESSION(SQL Table) |
Index Back |
|---|---|
T&L Mass Time SessionHold the Session information as entered via the Mass Time Employee or Manager self service pages. This information will be used by the Mass Time Batch process upon its submission. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ST_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Session Number
Default Value: 9999999999 |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | START_DATE | Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 4 | END_DATE | Date(10) | DATE | End Date |
| 5 | GROUP_ID | Character(5) | VARCHAR2(5) NOT NULL |
Group ID
Prompt Table: TL_GROUP_TBL |
| 6 | MASS_UPDATE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Update Status
1=In Progress 2=Ready 3=Submitted Default Value: 1 |
| 7 | MASS_USER_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Mass Time User Action
1=Use Schedule 2=Schedule with Hours 3=Specify Transactions |
| 8 | TL_ADDREP_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field designates whether time should be added to or replace a particular day's time.
A=Addition C=Correction R=Replacement Default Value: A |
| 9 | APPLY_OFFDAY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Apply to Off Days
Y/N Table Edit Default Value: N |
| 10 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table: TL_TASKGRP_VW |