Entity Relationships - LLWR Tables

A trainee's LLWR record is spread over a number of tables.

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
TRAINEE	Trainee Basic Details	TRAINEEID				Stores a trainee's basic details, such as name, address, etc.
TRAINEEPOT	Trainee Period of Training	TRAINEEID, POT	TRAINEE	One to many	TRAINEEID	Stores data for a specific period of training (POT), such as start date, termination date and contractor.
TRAINEEPOT2	Trainee POT Details 2	TRAINEEID, POT	TRAINEEPOT	One to one	TRAINEEID, POT	An extension of TRAINEEPOT data.
TRAINEEDETAILS	Trainee Trackable Info	TRAINEEID, Q_DETAILID	TRAINEEPOT	One to many	TRAINEEID, POT	Stores trackable, POT-specific data, such as aim reference and disability status.
TRAINEE_LLWR_ACT	LLWR Activities	TRAINEEID, POT, LACTI_ID	TRAINEEPOT	One to many	TRAINEEID, POT	Stores LLWR activities.
TRAINEE_LLWR_AWARD	LLWR Awards	TRAINEEID, POT, AWARD_NO	TRAINEE_LLWR_ACT	One to one	TRAINEEID, POT, LACTI_ID (to LACTLINK)	Stores LLWR awards.