Assignment: Palliative Care Job

Assignment: Palliative Care Job
Assignment: Palliative Care Job
Purpose in Summary
Verify the newly created user ID before we handed to the
employee
Input Data Flow(s)
New User send for verification
Output Data Flow(s)
Approved user ID, verification of user ID request
Data Store(s) Used
Verified / accepted user ID, user ID send request
Detailed Process
Usually connects the HR, system admin and visiting HCP.
Description
Received user id from system admin would send that user id
to HR for the verification purpose. Manager finally
approved new HCP user ID, then it given to new Visiting
HCP to the organisation.
TABLES
Name of Table: Visiting HCP
Name of Attribute 1
Employee Surname
Description
It consists of surname of visiting HCP
Data Type
Text
Length
Long (250)
Constraints
Can not contain any special character or numerical numbers
Name of Attribute 2
Employee Forename
Description
It consists of forename of visiting HCP
Data Type
Text
Length
Long (250)
Constraints
Can not contain any special character or numerical numbers
Name of Attribute 3
Date of birth
Description
It consists of date of birth of visiting HCP
Data Type
Date/time
12
Length
Date and time
Constraints
Only numerical can be filled but no alphabets
Name of Attribute 4
Occupation
Description
It consists of visiting HCP occupation
Data Type
Text
Length
Long (250 character allowed)
Constraints
Name of Attribute 5
Nursing Home user ID
Description
It is the individual identification number given to each employee
of the organisation. It is a primary key as it is unique for each
insured person.
Data Type
Auto Number
Length
Long digit
Constraints
Name of Attribute 6
Phone Number
Description
It consists of visiting HCP phone number for contacting.
Data Type
Number
Length
Long integer
Constraints
It cannot contain any alphabet.
13
Table 2: Period of Nursing Home visiting
Name of Attribute 1
Individual ID
Description
It is the individual identification number given to each
employee of the organisation. It is a primary key as it
is unique for each insured person
Data Type
Auto number
Length
Long digit
Constraints
Name of Attribute 2
Date of Joining
Description
It tells about the date of joining of the HCP into the
organization.
Data Type
Date/Time
Length
Date and time
Constraints
Date and time values only in numerals, no alphabet
allowed.
Name of Attribute 3
Date of last working day
Description
It is the date states that visiting HCP last working day
with the organisation
Data Type
Date/Time
Length
Date and time
Constraints
Date and time values only in numerical no alphabet
allowed.
14
Table 3: Resident details
Name of Attribute 1
Patient ID
Description
It is the resident’s identification number given to each
resident. It is a primary key as it is unique for every
resident in the organisation
Data Type
text
Length
Long digit
Constraints
Name of Attribute 2
Resident surname
Description
It consists of Resident surname
Data Type
Text
Length
Long (250character)
Constraints
Name of Attribute 3
Resident Forename
Description
It consists of Resident forename
Data Type
Text
Length
Long (250 characters)
Constrains
15
Table 4: Nursing Home details
Name of Attribute 1
Nursing user ID Home number
Description
This field is state about the unique number of the
Nursing Home
Data Type
Text
Length
Long (250 character)
Constraints
Name of Attribute 2
Name of the organization
Description
This field is state about name of the organization in
which visiting HCP going to visit by request.
Data Type
Text
Length
Long (250 character)
Constraints
Name of Attribute 3
Address of the Organisation
Description
It gives the address of the Nursing Home in which
visiting HCP going to visit by request.
Data Type
Text
Length
Long (250 character)
Constraints
16
17