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 |
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 |