tbl_formfinalrat

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
finalratid bigserial 19 √ nextval('tbl_formfinalrat_finalratid_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for the final rating record of a specific form submission.
formid int8 19 √ null
tbl_formdetail.formid Implied Constraint R

FK: public.tbl_formsubmission.id or similar (Presumed Foreign Key)
Meaning: The specific submitted form instance this rating belongs to.
Dependency: Links the final result to the employee’s completed review form.
ratlookid int2 5 √ null

FK: public.tbl_ratinglookup.id or similar (Presumed Foreign Key)
Meaning: The final calculated rating lookup value.
Example: Links to a rating scale entry like “Exceeds Expectations” or “3.5 out of 5”.
rep1rat int4 10 √ null

The rating given by the primary reviewer (typically the direct manager, Reporter 1).
Format: Numeric (e.g., Decimal or SmallInt)
Usage: The score provided by the first-level supervisor.
selfrat int4 10 √ null

The self-rating provided by the employee who was reviewed.
Format: Numeric (e.g., Decimal or SmallInt)
Usage: The employee’s own assessment of their performance.
rep2rat int4 10 √ null

The rating given by the secondary reviewer (typically a second-level manager, Reporter 2).
Format: Numeric (e.g., Decimal or SmallInt, nullable)
Usage: The score provided by the manager’s manager or an HR partner.
column1 int8 19 √ null

Custom Field 1
Meaning: Generic field for storing additional rating data (e.g., Normalized Score, Final Adjusted Score).
Format: Varchar/Decimal (Context-dependent)
column2 int8 19 √ null

Custom Field 2
Meaning: Generic field for storing additional rating data (e.g., Peer Review Average, Stakeholder Feedback Score).
Format: Varchar/Decimal (Context-dependent)
column3 varchar 50 √ null

Custom Field 3
Meaning: Generic field for storing additional rating data.
Format: Varchar/Decimal (Context-dependent)
column4 varchar 50 √ null

Custom Field 4
Meaning: Generic field for storing additional rating data.
Format: Varchar/Decimal (Context-dependent)
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The user (or system process) that created this final rating record.
createddate timestamp 29,6 √ null

Timestamp of when the final rating was created or calculated.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or similar (Presumed Foreign Key)
Meaning: The last user who modified this final rating record (e.g., HR adjustment).
modifieddate timestamp 29,6 √ null

Timestamp of when the final rating record was last modified.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ

Indexes

Constraint Name Type Sort Column(s)
tbl_formfinalrat_pk_tbl_formfinalrat Primary key Asc finalratid

Relationships

Close relationships within degrees of separation