P 2 K_SA_REVIEW_RATINGS

Alias: SRVR#

(P2K_SA_REVIEW_RATINGS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-SA04


Review Ratings

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
SRV_IDNumber(10)IDYlink to P2K_SA_REVIEWS
REVIEW_CATEGORYVarchar2(4)X_REVIEW_CATEGORYY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
REVIEW_RATINGVarchar2(16)VARCHAR16
REVIEW_POINTSNumber(5)NUMBER5
COMMENTSVarchar2(4000)VARCHAR4000

Derived Fields#

Column Name
DRV_MAXIMUM_POINTS
DRV_TOTAL_POINTS
DRV_WEIGHTING_POINTS

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page