TERM_RQST(SQL Table) |
Index Back |
|---|---|
Final Checks Request TblThis table holds all of the Final Check request for employees. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | TERM_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Final Check Processing Status
C=Paysheet Created N=Not Processed P=Loaded to Paysheets X=Extracted Default Value: N |
| 5 | REPROCESS | Character(1) | VARCHAR2(1) NOT NULL |
Reprocess?
Y/N Table Edit Default Value: N |
| 6 | TERM_PGM_ID | Character(3) | VARCHAR2(3) NOT NULL |
Final Check Program ID
Prompt Table: TERM_PGM_TBL |
| 7 | TERMINATION_DT | Date(10) | DATE NOT NULL | Termination Date |
| 8 | CREATED_FROM_JOB | Character(1) | VARCHAR2(1) NOT NULL |
Created From JOB Record
Y/N Table Edit Default Value: N |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 11 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 12 | OFF_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Off Cycle ? |
| 13 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
| 14 | LINE_NUM | Number(2,0) | SMALLINT NOT NULL | Line # |
| 15 | INCL_PYBL_TM | Character(1) | VARCHAR2(1) NOT NULL |
Include T&&L Payable Time
Y/N Table Edit Default Value: Y |
| 16 | DESCRLONG | Long Character | CLOB | Long Description |