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