TL_ST_PARMS_AET(SQL Table) |
Index Back |
|---|---|
Submit Time (TL_ST_LIB) state |
| # | 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 | CALL_TA | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the TA process should be run as a direct extension at the end of the Submit Time process.
With the introduction of the option of subjecting reported time to approval, this may in cases no longer be a viable option.
0=Don't Automatically Run Rules 1=Automatically Run Rules |
| 5 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 8 | END_DT | Date(10) | DATE | end date |
| 9 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 10 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 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 | ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Submit Time Instance |
| 13 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |
| 14 | ST_RTNCD | Number(4,0) | SMALLINT NOT NULL | SubmitTime Return Code |
| 15 | ST_RTNCD_RSN | Character(100) | VARCHAR2(100) NOT NULL | Submit Time Return Code Reason |
| 16 | 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 |
| 17 | TL_RPTD_TIME_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Reported Time Exist |
| 18 | TIME_RPTR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether a Time Reporter is primarily reports Elapsed Time or Punch Time.
E=Elapsed Time Reporter P=Punch Time Reporter |