TL_MASS_TM_AET(SQL Table) |
Index Back |
|---|---|
Mass Time State RecordMain State Record for Mass Time. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Submit Time Instance |
| 3 | MASS_USER_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Mass Time User Action
1=Use Schedule 2=Schedule with Hours 3=Specify Transactions |
| 4 | EXISTS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This Flag tells if we should use Exists, or Not Exists as a predicate prefixing the SubQuery.
0=Exists 1=Not Exists |
| 5 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 6 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 7 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 8 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 9 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 10 | END_DATE | Date(10) | DATE | End Date |
| 11 | RT_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Reported Time Source. the originator of Reported Time
AM=Absence Management MD=Mobile Device ONL=Online SCH=Schedule SYS=Time and Labor System TCD=Time Collection Device |
| 12 | TOTAL_SCH_HRS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Scheduled Hours |
| 13 | 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 |