Previous Topic: ca_job_function TableNext Topic: ca_location Table


ca_job_title Table

Job title descriptions (CA-MDB).

Field

Data Type

Reference

Remarks

creation_date

INTEGER

 

Specifies the date of when this record was created.

creation_user

nvarchar(64)

 

Identifies the user or process that created the record.

delete_time

INTEGER

 

Indicates the time of deletion.

exclude_
registration

INTEGER

 

Indicates to exclude registration.

id

INTEGER

 

Identifies the unique (to the table) numeric job title ID.
Note: This is a Primary key.

inactive

INTEGER

Active_Boolean_ Table::enum

Specifies the Active flag, as follows:
0—False (Active)
1—True (Inactive)

last_update_date

INTEGER

 

Indicates the date of when this record was last updated.

last_update_user

varchar(64)

 

Specifies the user or process that last updated the record.

name

varchar(100)

 

Specifies the job title name.

version_number

INTEGER

 

Specifies the version number for transaction integrity.