!!!Alias: IVDAA (INF_CV_AUTHORIZATIONS) The INF_CV_AUTHORIZATIONS table is used to import Authorization Areas into the software data structures. The authorization area is a security feature that enables an organization to control access to people information. A default authorization area is associated with a position or a department. When a person is hired or transferred, the position's authorization area is automatically inherited by the work assignment, but the user may override it as required. Tables loaded: [P2K_CM_AUTHORIZATION_AREAS] !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[ENTITY_CODE]|Varchar2(16)|Y|Validation: Must be a valid entity code defined on [P2K_CM_ENTITIES] |[AUTHORIZATION_CODE]|Varchar2(16)|Y|Validation: Must be a unique authorization code defined for this entity. |[DESCRIPTION]|Varchar2(50)| | |[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| | This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.INF_CV_AUTHORIZATIONS] [{InsertPage page='Internal.INF_CV_AUTHORIZATIONS' default='Click to create a new discussion page'}] }]