Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HPerson Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | RecordId of the person's job information |
Description | varchar(14) | NULL | Not Used |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HOccupation row |
CreationTime | smalldatetime | NULL | Date and Time when the row was created |
JobTitle | varchar(30) | NULL | Person's designation or title(e.g., Manager, Vice-President) at the workplace. |
JobCode | varchar(20) | NULL | Free text description of the person's job entered by the user during registration. |
Classification | varchar(50) | NULL | Free text description of the person's job classification entered by the user during registration. |
JobStatus | varchar(64) | NULL | Person's job status.(e.g.,full time,part time, permanent employee, temporary employee). |
JoiningDate | datetime | NULL | Date and Time when the person began the job. |
TerminationDate | datetime | NULL | Date and Time when the person left the job. |
PresentOccupation | bit | NULL | Present Occupation status. Allowable Values: 0 - False, 1 - True , Null - Not valued |
EmployeeNumber | varchar(20) | NULL | Unique identity number assigned to the person. |
OrganizationName | varchar(50) | NULL | Organization name where the person is employed. |
OrganizationAddress | varchar(100) | NULL | Address of the organization where the person is employed. |
IsPrimary | bit | NULL | Specified job is the person's primary source of income. Allowable Values: 0 - False, 1 - True, Null - Not valued |
Person_oid | int | NOT NULL | ObjectID of the person associated with occupation row. This ObjectID must exist in HPerson table. |
LastCngDtime | datetime | NULL | UTC date and time when person occupation was last changed. |
|