Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Position
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PositionCode | CHARACTER(8) | MANDATORY | Position code which identifies position. User entered. | |
| Name | CHARACTER(30) | MANDATORY | Name of the position. User entered. | |
| PatientAssignable | CHARACTER(1) | MANDATORY | Patient assignable indicator, (Y)es position may have patients assigned or (N)o otherwise. User entered. | |
| Billable | CHARACTER(1) | MANDATORY | Billable indicator, (Y)es - position is billable or (N)o otherwise. User entered. | |
| Scheduled | CHARACTER(1) | MANDATORY | Scheduled indicator, (Y)es - position may be scheduled or (N)o otherwise. User entered. | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| RxAllowed | CHARACTER(1) | MANDATORY | This flag indicates whether or not this position may write prescriptions. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting Position record... |
|---|---|---|
| Staff | Staff.PositionCode = Position.PositionCode | RESTRICT if Staff exists |