EMPLIDEMPL_RCDEFFDTA=Active
I=Inactive
Default Value: A
Prompt Table: TL_WRKGRP_TBL
Prompt Table: TL_TASKGRP_TBL
Prompt Table: TL_TASKGRP_PRFL
TL_EMPL_WKLY_VW(SQL View) |
Index Back |
|---|---|
Time Employee Weekly ProfileThis record defines the employee information needed to allow the employee to be processed by Time and Labor via the reported time weekly view. |
| SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.TIME_RPTG_STATUS ,A.WORKGROUP ,A.TASKGROUP ,A.TASK_PROFILE_ID ,A.ELP_TR_TMPLT_ID FROM PS_TL_EMPL_DATA A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | TIME_RPTG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporter Status
A=Active I=Inactive Default Value: A |
| 5 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Workgroup
Prompt Table: TL_WRKGRP_TBL |
| 6 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL |
Taskgroup
Prompt Table: TL_TASKGRP_TBL |
| 7 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL |
Task Profile ID
Prompt Table: TL_TASKGRP_PRFL |
| 8 | ELP_TR_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Elapsed Reporting Template |