EMPLIDEMPL_RCDFP_EFFDTFP_TYPE_BRKY/N Table Edit
Default Value: N
Prompt Table: SETID_TBL
Prompt Table: FPMRANK_VW1
Prompt Table: FP_SETID_DPT_VW
Prompt Table: FP_DEPTMNT_VW
FPA_RATPRS_VW(SQL View) |
Index Back |
|---|---|
Attendance for Evaluation view |
| SELECT EMPLID , EMPL_RCD , EFFDT , FP_TYPE_BRK , FP_RATPRS_GR , FP_BEGIN_DT_RATING , FP_END_DT_RATING , FP_SETID_RANK , FP_RANK_CD , SETID_DEPT , DEPTID , FP_RATING_PRS FROM PS_FPA_RATPRS_TBL |
| # | 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 | FP_EFFDT |
Date(10) | DATE | Computer Date |
| 4 | FP_TYPE_BRK |
Character(1) | VARCHAR2(1) NOT NULL | Type of Attendance Time |
| 5 | FP_RATPRS_GR | Character(1) | VARCHAR2(1) NOT NULL |
Majority AttendanceTime
Y/N Table Edit Default Value: N |
| 6 | FP_BEGIN_DT_RATING | Date(10) | DATE | Rating Start Date |
| 7 | FP_END_DT_RATING | Date(10) | DATE | Rating End Date |
| 8 | FP_SETID_RANK | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 9 | FP_RANK_CD | Character(6) | VARCHAR2(6) NOT NULL |
Grade
Prompt Table: FPMRANK_VW1 |
| 10 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Prompt Table: FP_SETID_DPT_VW |
| 11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: FP_DEPTMNT_VW |
| 12 | FP_RATING_PRS | Number(3,0) | SMALLINT NOT NULL | Rating Attendance |