FCM_ORG_UNITS
This table stores the organizational unit information.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
FCM_ORG_UNITS_PK |
ORG_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
ORG_ID |
NUMBER |
18 |
0 |
No |
Organization Unit ID (Unique key) |
|
|
ORG_NAME |
VARCHAR2 |
255 |
No |
Organization Unit Name |
||
|
PARENT_ORG_ID |
NUMBER |
18 |
0 |
Yes |
Parent Organization Unit ID |
|
|
DESCRIPTION |
VARCHAR2 |
4000 |
Yes |
Description |
||
|
HOLIDAY_RULE_ID |
NUMBER |
18 |
0 |
Yes |
Holiday rule ID |
|
|
ARM_CALENDAR_ID |
NUMBER |
18 |
0 |
Yes |
ARM calendar ID |
|
|
ARM_WORK_DAYS |
VARCHAR2 |
30 |
Yes |
Stores string of format 1-2-3-4-5-6-7 for workdays. 1- Sunday and 7 - Saturday. |
||
|
ORDER_SEQ |
NUMBER |
3 |
0 |
Yes |
The relative order |
|
|
ORG_CODE |
VARCHAR2 |
255 |
No |
The org unit unique code |
||
|
DELETED |
VARCHAR2 |
1 |
Yes |
Whether the org unit has been logically deleted. |
||
|
OBJECT_VERSION_NUMBER |
NUMBER |
9 |
0 |
No |
Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
|
|
LAST_UPDATE_LOGIN |
NUMBER |
Yes |
Who column. Stores the login/session ID of the user who last updated this row. |
|||
|
LAST_UPDATED_BY |
VARCHAR2 |
255 |
No |
Who column. Stores the ID of the user who last updated this row. |
||
|
LAST_UPDATE_DATE |
DATE |
No |
Who column. Stores the date when this row was last updated. |
|||
|
CREATED_BY |
VARCHAR2 |
255 |
No |
Who column. Stores the ID of the user who created this row. |
||
|
CREATION_DATE |
DATE |
No |
Who column. Stores the date when this row was created in the database. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| FCM_ORG_UNITS_N1 | NONUNIQUE | PARENT_ORG_ID |
| FCM_ORG_UNITS_PK | UNIQUE | ORG_ID |