Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOccupation Contains person's job information
Column Name Column Datatype Column Null Option Column Comment
ObjectIDintNOT NULL ObjectId of HPerson Rows generated by Architecture
InstanceHFCIDsmallintNOT NULL Instance HFC(Healthcare Foundation Class) ID generated by Architecture
RecordIdintNULL RecordId of the person's job information
Descriptionvarchar(14)NULL Not Used
IsVersionedbitNOT NULL Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified
CreatedUserIdintNULL UserId of the user who created the HOccupation row
CreationTimesmalldatetimeNULL Date and Time when the row was created
JobTitlevarchar(30)NULL Person's designation or title(e.g., Manager, Vice-President) at the workplace.
JobCodevarchar(20)NULL Free text description of the person's job entered by the user during registration.
Classificationvarchar(50)NULL Free text description of the person's job classification entered by the user during registration.
JobStatusvarchar(64)NULL Person's job status.(e.g.,full time,part time, permanent employee, temporary employee).
JoiningDatedatetimeNULL Date and Time when the person began the job.
TerminationDatedatetimeNULL Date and Time when the person left the job.
PresentOccupationbitNULL Present Occupation status. Allowable Values: 0 - False, 1 - True , Null - Not valued
EmployeeNumbervarchar(20)NULL Unique identity number assigned to the person.
OrganizationNamevarchar(50)NULL Organization name where the person is employed.
OrganizationAddressvarchar(100)NULL Address of the organization where the person is employed.
IsPrimarybitNULL Specified job is the person's primary source of income. Allowable Values: 0 - False, 1 - True, Null - Not valued
Person_oidintNOT NULL ObjectID of the person associated with occupation row. This ObjectID must exist in HPerson table.
LastCngDtimedatetimeNULL UTC date and time when person occupation was last changed.

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates