TL_AENRL_AET(SQL Table) |
Index Back |
|---|---|
Auto Enrollment State RecordAuto Enrollment State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | TL_CRITERIA_ID | Character(12) | VARCHAR2(12) NOT NULL | Enrollment Group |
| 3 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 4 | PROCESSED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Used for Leave Donations Batch Process to indicate whether to process a request or not.
N=Processing Not Applicable X=Processing Cancelled Y=Process |
| 5 | SCH_AENRL_PRCS_FLG | Character(3) | VARCHAR2(3) NOT NULL |
Schedule AEnrollment Prcs Flg
CMP=Completed ERR=Error IGR=Ignored IPR=In Process NPR=Not Processed STG=Staged |
| 6 | TL_AENRL_PRCS_FLG | Character(3) | VARCHAR2(3) NOT NULL |
TL Auto Enrollment Prcs Flg
CMP=Completed ERR=Error IGR=Ignored IPR=In Process NPR=Not Processed STG=Staged |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | TL_CRITERIA_EFFDT | Date(10) | DATE | TL Criteria Eff Date |
| 9 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 10 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 11 | FROMDATE | Date(10) | DATE | From Date |
| 12 | THRUDATE | Date(10) | DATE | End Date |
| 13 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 14 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 15 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 16 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 17 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 18 | SUPERVISOR_ID | Character(11) | VARCHAR2(11) NOT NULL | Supervisor ID |
| 19 | REPORTS_TO | Character(8) | VARCHAR2(8) NOT NULL | Reports To Position Number |
| 20 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 21 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 22 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 23 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 24 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 25 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 26 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 27 | EFFDT | Date(10) | DATE | Effective Date |
| 28 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 29 | DESCRLONG | Long Character | CLOB | Long Description |
| 30 | TL_RUN_SOURCE | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 31 | TL_RUN_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
T&L Auto enrollment feature - Run control field options
A=All Employees Q=Process Group Query S=Select Employees |
| 32 | 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 |
| 33 | TL_PREVIEW_MODE | Character(1) | VARCHAR2(1) NOT NULL | Preview Mode |
| 34 | TL_EXCLUDE_PRVW | Character(1) | VARCHAR2(1) NOT NULL | Exclude |
| 35 | ASOFDATE | Date(10) | DATE | As of Date |