Work Request Status Change History

Table

Database	Table	Entity	On Key 5 Conversions	On Key 5 Tables	Other Entities stored in same Table
Transaction	wm.work_request_status_change_history	Work Request Status Change History

Columns

Property	Db Table	Db Column	Db DataType	Nullable	Primary Key	Joins
CreatedByUserId	wm.work_request_status_change_history	created_by_user_id	bigint	False
CreatedByUserCode	uam.user	code	character varying(50)	False		wm.work_request_status_change_history.created_by_user_id = uam.user.user_id
CreatedByUserFullName	uam.user	full_name	character varying(200)	False		wm.work_request_status_change_history.created_by_user_id = uam.user.user_id
CreatedOn	wm.work_request_status_change_history	created_on	timestamp without time zone	False
Id	wm.work_request_status_change_history	work_request_status_change_history_id	bigint	False	True
ElapsedTime	wm.work_request_status_change_history	elapsed_time	interval	True
StatusChangedOn	wm.work_request_status_change_history	status_changed_on	timestamp without time zone	False
IsLatest	wm.work_request_status_change_history	is_latest	boolean	False
NewStatusId	wm.work_request_status_change_history	new_status_id	bigint	False
NewStatusCode	wm.work_request_status	code	character varying(50)	False		wm.work_request_status_change_history.new_status_id = wm.work_request_status.work_request_status_id
NewStatusDescription	wm.work_request_status	description	character varying(100)	False		wm.work_request_status_change_history.new_status_id = wm.work_request_status.work_request_status_id
OldStatusId	wm.work_request_status_change_history	old_status_id	bigint	True
OldStatusCode	wm.work_request_status	code	character varying(50)	False		wm.work_request_status_change_history.old_status_id = wm.work_request_status.work_request_status_id
OldStatusDescription	wm.work_request_status	description	character varying(100)	False		wm.work_request_status_change_history.old_status_id = wm.work_request_status.work_request_status_id
PredecessorId	wm.work_request_status_change_history	predecessor_id	bigint	True
Remark	wm.work_request_status_change_history	remark	text	True
WorkRequestId	wm.work_request_status_change_history	work_request_id	bigint	False
WorkRequestCode	wm.work_request	code	character varying(50)	False		wm.work_request_status_change_history.work_request_id = wm.work_request.work_request_id
WorkRequestDescription	wm.work_request	description	character varying(100)	False		wm.work_request_status_change_history.work_request_id = wm.work_request.work_request_id
WorkRequestWorkRequested	wm.work_request	work_requested	text	False		wm.work_request_status_change_history.work_request_id = wm.work_request.work_request_id

Queries

The list of example Work Request Status Change History queries can be interpreted using the following legend:

Legend	Description
Primary Table Alias	The alias for the wm.work_request_status_change_history table in the query
Include References	Include (true) or exclude (false) all lookup table joins in the query
Include Permissions	Include (true) or exclude (false) the permission table join in the query to enforce or skip row-level security based on the permissions for the user

Query 1

Primary Table Alias	Include References	Include Permissions
_wrsch	False	False

SELECT
    _wrsch.created_by_user_id AS "CreatedByUserId",
    _wrsch.created_on AS "CreatedOn",
    _wrsch.work_request_status_change_history_id AS "Id",
    _wrsch.elapsed_time AS "ElapsedTime",
    _wrsch.status_changed_on AS "StatusChangedOn",
    _wrsch.is_latest AS "IsLatest",
    _wrsch.new_status_id AS "NewStatusId",
    _wrsch.old_status_id AS "OldStatusId",
    _wrsch.predecessor_id AS "PredecessorId",
    _wrsch.remark AS "Remark",
    _wrsch.work_request_id AS "WorkRequestId"
FROM
    wm.work_request_status_change_history _wrsch

Query 2

Primary Table Alias	Include References	Include Permissions
_wrsch	True	False

SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _wrsch.created_on AS "CreatedOn",
    _wrsch.work_request_status_change_history_id AS "Id",
    _wrsch.elapsed_time AS "ElapsedTime",
    _wrsch.status_changed_on AS "StatusChangedOn",
    _wrsch.is_latest AS "IsLatest",
    _wrs.work_request_status_id AS "NewStatusId",
    _wrs.code AS "NewStatusCode",
    _wrs.description AS "NewStatusDescription",
    _wrs1.work_request_status_id AS "OldStatusId",
    _wrs1.code AS "OldStatusCode",
    _wrs1.description AS "OldStatusDescription",
    _wrsch1.work_request_status_change_history_id AS "PredecessorId",
    _wrsch.remark AS "Remark",
    _wr.work_request_id AS "WorkRequestId",
    _wr.code AS "WorkRequestCode",
    _wr.description AS "WorkRequestDescription",
    _wr.work_requested AS "WorkRequestWorkRequested"
FROM
    wm.work_request_status_change_history _wrsch
    JOIN uam.user _u ON _wrsch.created_by_user_id = _u.user_id
    JOIN wm.work_request_status _wrs ON _wrsch.new_status_id = _wrs.work_request_status_id
    LEFT JOIN wm.work_request_status _wrs1 ON _wrsch.old_status_id = _wrs1.work_request_status_id
    LEFT JOIN wm.work_request_status_change_history _wrsch1 ON _wrsch.predecessor_id = _wrsch1.work_request_status_change_history_id
    JOIN wm.work_request _wr ON _wrsch.work_request_id = _wr.work_request_id