probationformstatuspmsnew

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('probationformstatuspmsnew_id_seq'::regclass)
formid int8 19 √ null
tbl_formdetail.formid Implied Constraint R
employeeid varchar 50 √ null
emprat bool 1 √ null
rep1rat bool 1 √ null
rep2rat bool 1 √ null
finalstatus bool 1 √ null
levelofassessment int4 10 √ null
effectivedate timestamp 29,6 √ null
reviewstatus int2 5 √ null
companyid int8 19 √ null
col1 int4 10 √ null
col2 varchar 50 √ null
statusatlast bool 1 √ null
effectivedate2 timestamp 29,6 √ null
days2 int4 10 √ null
comments2 varchar 50 √ null
col3 int4 10 √ null
col4 varchar 50 √ null
col5 varchar 50 √ null
col6 varchar 50 √ null
col7 varchar 500 √ null
col8 varchar 500 √ null
appraisaldate timestamp 29,6 √ null
col9 varchar 500 √ null
col10 varchar 500 √ null
empstep int4 10 √ null
rep1step int4 10 √ null
rep2step int4 10 √ null
finalrat1 numeric 0 √ null
finalrat2 numeric 0 √ null
finalrat3 numeric 0 √ null
finalrat4 numeric 0 √ null
marketstandard1 numeric 0 √ null
marketstandard2 numeric 0 √ null
marketcmt1 varchar 500 √ null
marketcmt2 varchar 500 √ null
bonus1 numeric 0 √ null
bonus2 numeric 0 √ null
bonuscmt1 varchar 500 √ null
bonuscmt2 varchar 500 √ null
incrcmt1 varchar 500 √ null
incrcmt2 varchar 500 √ null
empfinalrat numeric 0 √ null
rep1finalrat numeric 0 √ null
rep2finalrat numeric 0 √ null
finalcalrat numeric 0 √ null
finalspec varchar 50 √ null
hrincrementrecommnd numeric 0 √ null
promotiondesignation varchar 100 √ null
promotiondate timestamp 29,6 √ null
newctcdate timestamp 29,6 √ null
hrfinalrat numeric 0 √ null
hrfinalincrement numeric 0 √ null
hrnewctc numeric 0 √ null
hrnewctceffectivedate timestamp 29,6 √ null
hrnewdesignation int4 10 √ null
hrnewgrade int4 10 √ null
hrdesgandgradeedate timestamp 29,6 √ null
hrfreeze bool 1 √ false
hrapproved bool 1 √ false
currentapp int4 10 √ null
hrmarketstandard numeric 0 √ '0'::numeric
hrbonus numeric 0 √ '0'::numeric
goaleffectivedate timestamp 29,6 √ null
reporting1ext varchar 50 √ null
reporting2ext varchar 50 √ null
latestcycle bool 1 √ false
finalunround numeric 0 √ null
finalround int4 10 √ null
finalspecification varchar 50 √ null
isregular bool 1 √ false
isnewemployee bool 1 √ false
stage varchar 50 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
pms_goal_list_id int8 19 √ null
tbl_pmsgoallist.id fk_pms_goal_list_id R
emptemplatetype1rat numeric 0 √ null
rep1templatetype1rat numeric 0 √ null
rep2templatetype1rat numeric 0 √ null
emptemplatetype2rat numeric 0 √ null
rep1templatetype2rat numeric 0 √ null
rep2templatetype2rat numeric 0 √ null
empsectionwiserat numeric 0 √ null
rep1sectionwiserat numeric 0 √ null
rep2sectionwiserat numeric 0 √ null
templatetype1name varchar 300 √ null
templatetype2name varchar 300 √ null

Indexes

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

Relationships

Close relationships within degrees of separation