CAN_PAYEQ_JOB_CLSEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
CAN_PAYEQ_TBL(SQL Table) |
Index Back |
|---|---|
CAN Pay Equity CodesCanada only. CAN_PAYEQ_TBL is used to store data concerning pay equity among job classes. Each job class is assigned points in several categories including skill required, effort required, responsibility involved, and work conditions, and a point total is produced. These points and totals produce a scale that allows jobs to be compared to one another. This functionality is located in the Regulatory Requirements Canada application. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAN_PAYEQ_JOB_CLS |
Character(3) | VARCHAR2(3) NOT NULL | Canadian Pay Equity Job Class |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | PAYEQ_SKILL_PTS | Number(5,0) | INTEGER NOT NULL | Pay Equity Skill Points |
| 5 | PAYEQ_EFFORT_PTS | Number(5,0) | INTEGER NOT NULL | Pay Equity Effort Points |
| 6 | PAYEQ_RESP_PTS | Number(5,0) | INTEGER NOT NULL | Pay Equity Responsibility Pts |
| 7 | PAYEQ_WORKCOND_PTS | Number(5,0) | INTEGER NOT NULL | Pay Equity Working Cond Points |
| 8 | PAYEQ_TOTAL_PTS | Number(6,0) | INTEGER NOT NULL | Pay Equity Total Points |