TL_RAPID_TM_AET

(SQL Table)
Index Back

Rapid Time State Record

Parameter record used for the TL_SUBMITALL routine which is the connector to TL_ST_LIB for Rapid Time

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 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
3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 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
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
9 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
10 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Submit Time Instance
11 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
12 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
13 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
14 TL_TASK_SUM Character(243) VARCHAR2(243) NOT NULL Task Sum
15 TL_TRC_SUM Character(54) VARCHAR2(54) NOT NULL Sum TRC