FPA_RATPRS_TBL(SQL Table) |
Index Back |
---|---|
Attendance for Evaluation |
# | 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 Record |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %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 Attendance Time
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 | Set ID |
9 | FP_RANK_CD | Character(6) | VARCHAR2(6) NOT NULL |
Grade
Prompt Table: FPMRANK_TBL |
10 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
11 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
12 | FP_RATING_PRS | Number(3,0) | SMALLINT NOT NULL | Rating Attendance |