TL_ST_PARMS_AET

(SQL Table)
Index Back

# 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 ST_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Session Number
5 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 Source
SYS=Time and Labor System
TCD=Time Collection Device
6 ST_RTNCD Number(4,0) SMALLINT NOT NULL SubmitTime Return Code
7 ST_RTNCD_RSN Character(100) VARCHAR2(100) NOT NULL Submit Time Return Code Reason
8 TL_PRCS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
9 KEEP_GOING Character(1) VARCHAR2(1) NOT NULL Keep Going Flag for App Engine....
10 CALL_TA Character(1) VARCHAR2(1) NOT NULL Used in the TL_AGG_MAIN_AET state record to communicate that Rules should be run after the Aggregate Update process.
0=Don't Automatically Run Rules
1=Automatically Run Rules
11 TL_RPTD_TIME_EXIST Character(1) VARCHAR2(1) NOT NULL Reported Time Exist
12 EXIST Character(1) VARCHAR2(1) NOT NULL Currency Exist
13 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
  • 14 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