TL_ABS_INT_AET(SQL Table) |
Index Back |
|---|---|
TL Absence Payable TimeState Record - TL Absence Payable Time. |
| # | 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 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table: GP_CAL_RUN_SRCH |
| 5 | TXN_ID | Number(5,0) | INTEGER NOT NULL |
Transaction ID
Default Value: 0 |
| 6 | STRM_NUM | Number(4,0) | SMALLINT NOT NULL |
Stream Number
Prompt Table: GP_STRM |
| 7 | GROUP_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Group List
Prompt Table: GP_GRP_LIST_VW |
| 8 | RUN_IDNT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Identify Payees to Calculate
Y/N Table Edit Default Value: N |
| 9 | RUN_CALC_IND | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Payees
Y/N Table Edit Default Value: N |
| 10 | RUN_RECALC_ALL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Recalculate All Payees
Y/N Table Edit Default Value: N |
| 11 | RUN_FINAL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Finalize Entire Run
Y/N Table Edit Default Value: N |
| 12 | RUN_CANCEL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Entire Run
Y/N Table Edit Default Value: N |
| 13 | RUN_SUSPEND_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicator field introduced on GP RUNCTL table giving user Suspend as a process option for GP Absence and Payroll processing
Default Value: N |
| 14 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 15 | CALC_RSLT_EXISTS | Character(1) | VARCHAR2(1) NOT NULL | Cal results exists |
| 16 | MAX_DATE | Date(10) | DATE | Maximum Date |