probationformstatus

-1 rows


Description

Module: Onboarding & Confirmation Management
Purpose: Tracks the status, scores, and decisions related to an employee’s probation or employment confirmation review.
Data: Captures the employee, the form used, review statuses, effective dates of change, and final outcomes (confirmation, extension, termination).
Process Usage:
- Initiated upon the employee’s probation due date approaching.
- Used to track the rating submission status by the employee (EmpRat) and managers (Rep1Rat, Rep2Rat).
- Records the final confirmation/extension decision and details.
Key Points:
- Critical for managing the transition from probationer to permanent employee.
- Tracks the final rating and decision for audit purposes.
Business Impact: Directly affects employee status, benefits eligibility, and employment continuity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('probationformstatus_id_seq'::regclass)
tbl_probratingmaster.probationformstatusid Implied Constraint R

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for a single employee’s probation review status record.
formid int8 19 √ null
tbl_formdetail.formid Implied Constraint R

FK: public.tbl_FormDetail.FormID
Meaning: The specific review form template used for this probation review.
employeeid varchar 50 √ null

FK: public.tbl_employee.employeeid
Meaning: The identifier of the employee whose probation status is being tracked.
emprat bool 1 √ null

Boolean flag: Has the Employee (Self) submitted their review/rating? (true/false)
rep1rat bool 1 √ null

Boolean flag: Has Reporting Manager 1 (M1) submitted their review/rating? (true/false)
rep2rat bool 1 √ null

Boolean flag: Has Reporting Manager 2 (M2) submitted their review/rating? (true/false)
finalstatus bool 1 √ null

Boolean flag: The final outcome of the review.
Meaning: Typically true for Confirmed, false for Extended/Terminated (though this depends on system convention).
levelofassessment int4 10 √ null

The configured number of required review levels/raters for this specific review instance.
effectivedate timestamp 29,6 √ null

The official date the final decision (Confirmation/Extension) takes effect (often the same as or slightly after ProbationDueDate).
reviewstatus int2 5 √ null

Integer code representing the current overall status of the probation review workflow.
Values: e.g., 1 (Pending M1), 2 (Pending M2), 3 (Pending HR), 4 (Completed).
companyid int8 19 √ null

FK: public.tbl_CompanyDetail.CompID
Meaning: The company the employee belongs to.
col1 int4 10 √ null

A generic Long field (Col1) for custom data or legacy storage.
col2 varchar 300 √ null

A generic String field (Col2) for custom data or legacy storage.
statusatlast bool 1 √ null

A flag indicating the final determined status (e.g., Confirmed, Extended, Terminated) based on the entire process.
effectivedate2 timestamp 29,6 √ null

A secondary effective date, potentially for a subsequent extension or final termination date.
days2 int4 10 √ null

The number of extension days or notice days related to EffectiveDate2.
comments2 varchar 300 √ null

Comments related to the extension or secondary effective date.
col3 int4 10 √ null

A generic Integer field (Col3) for custom data or legacy storage.
col4 varchar 50 √ null

A generic String field (Col4) for custom data or legacy storage.
hrstatus bool 1 √ false

Boolean flag: Has the HR department completed the final sign-off/review? (true/false)
isprocess bool 1 √ false

Boolean flag: Indicates if the final confirmation process (HR/Admin steps) has been completed.
probationduedate timestamp 29,6 √ null

The original contractual date on which the employee’s probation period was due to end.
finalrat numeric 0 √ null

Java Field: rat
Meaning: The final, consolidated overall rating/score achieved by the employee in the review (e.g., 4.2 out of 5).
finalspec varchar 50 √ null

Java Field: spec
Meaning: The final, textual specification or remark (e.g., “Confirmed”, “3-Month Extension”, “Not Confirmed”).
attachment varchar 500 √ null

File path/ID for the final signed review form or confirmation letter.
rep1extensiondate timestamp 29,6 √ null

The new probation due date proposed/approved by Manager 1 in case of an extension.
rep2extensiondate timestamp 29,6 √ null

The new probation due date proposed/approved by Manager 2 in case of an extension.
extendcount int4 10 0

The number of times the employee’s probation period has been formally extended.
createdby varchar 500 √ null
modifiedby varchar 500 √ null
createddate timestamp 29,6 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
probationformstatus_pk_probationformstatus Primary key Asc id

Relationships

Close relationships within degrees of separation