This page (revision-4) was last changed on 26-Nov-2021 10:22 by JEscott

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB JEscott to previous
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 1 KB RForbes to previous | to last
1 26-Nov-2021 10:22 2 KB RForbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 8 lines
!!!Alias: RAS
(P2K_RE_ASSESSMENTS)
Unique Keys: \\
Child Table: \\
Parent Table: \\
ERD: [ERD-RE50]
!!!Alias: RAP
Unique Keys: ___\\
Child Table: ___\\
Parent Table: ___\\
At line 10 changed one line
Assessments
Applications
At line 16 changed 6 lines
|[CTS_ID]|Number(10)|[ID]| |link to [P2K_CP_TRAINING_SUPPLIERS]
|[ASSESSMENT_CODE]|Varchar2(16)|[CODE]|Y|
|[COMPETENCE_GROUP]|Varchar2(2)|[X_COMPETENCE_GROUP]|Y|
|[ASSESSMENT_STATUS]|Varchar2(2)|[X_ASSESSMENT_STATUS]|Y|
|[ASSESSMENT_TYPE]|Varchar2(2)|[X_ASSESSMENT_TYPE]|Y|
|[ASSESSMENT_CATEGORY]|Varchar2(2)|[X_ASSESSMENT_CATEGORY]| |
|[RPO_ID]|Number(10)|[ID]|Y|link to [P2K_RE_POSTINGS]
|[RCA_ID]|Number(10)|[ID]|Y|link to [P2K_RE_CANDIDATES]
|[DEN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_ENTITIES]
|[RST_ID]|Number(10)|[ID]|Y|link to [P2K_RE_RECRUITING_STAGES]
|[EAS_ID]|Number(10)|[ID]| |link to [P2K_HR_ASSIGNMENTS]
|[SWSS_ID]|Number(10)|[ID]| |link to [P2K_SA_WAGE_SCALE_STEPS]
|[APPLICATION_CODE]|Varchar2(16)|[CODE]|Y|
|[APPLICATION_STATUS]|Varchar2(2)|[X_APPLICATION_STATUS]|Y|
|[APPLICATION_STAGE]|Varchar2(2)|[X_APPLICATION_STAGE]|Y|
|[APPLICATION_OPENED]|Date()|[DATE]|Y|
|[APPLICATION_CLOSED]|Date()|[DATE]| |
At line 23 changed 14 lines
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[FONT_HTML]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[WEB_ADDRESS]|Varchar2(200)|[URL]| |
|[EXTERNAL_ASSESSMENT_ID]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[DESIRED_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[ESSENTIAL_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[MAXIMUM_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[REQUIRED_GRADE]|Number(7)|[AMT5V2|AMTnn]| |
|[ANONYMOUS]|Varchar2(1)|[TOGGLE]| |
|[ALLOW_QUESTION_REVIEW]|Varchar2(1)|[TOGGLE]| |
|[SHOW_WEIGHTING]|Varchar2(1)|[TOGGLE]| |
|[ASSESSMENT_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
|[MUST_BE_SCHEDULED]|Varchar2(1)|[TOGGLE]| |
|[IMAGE_LOCATION]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[APPLICATION_RATING]|Varchar2(2)|[X_APPLICATION_RATING]| |
|[OFFERED_DATE]|Date()|[DATE]| |
|[RESPONSE_DATE]|Date()|[DATE]| |
|[RESPONSE_INDICATION]|Varchar2(2)|[X_RESPONSE_INDICATION]| |
|[REASON_FOR_REJECTION]|Varchar2(2)|[X_REASON_FOR_REJECTION]| |
|[REASON_FOR_DECLINE]|Varchar2(2)|[X_REASON_FOR_DECLINE]| |
|[ASSIGNMENT_START_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_END_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_TITLE]|Varchar2(50)|[DESCRIPTION]| |
|[FTE]|Number(9)|[AMT5V4|AMTnn]| |
|[HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| |
|[HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| |
|[RATE_BASIS]|Varchar2(2)|[X_RATE_BASIS]| |
|[SCALE_OVERRIDDEN]|Varchar2(1)|[TOGGLE]| |
|[APPLICATION_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
At line 44 added 4 lines
|[SALARY_FROM]|Number(18)|[AMT12V6|AMTnn]| |
|[SALARY_TO]|Number(18)|[AMT12V6|AMTnn]| |
|[REFERENCE_SOURCE]|Varchar2(2)|[X_REFERENCE_SOURCE]| |
|[MOTIVATION_TO_APPLY]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| |
At line 42 removed 5 lines
!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_APPROVAL_BAR]
At line 49 removed 5 lines
----
![Notes|Edit:Internal.P2K_RE_ASSESSMENTS]
[{InsertPage page='Internal.P2K_RE_ASSESSMENTS' default='Click to create a new notes page'}]