This page (revision-7) was last changed on 26-Nov-2021 10:22 by JMyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
7 26-Nov-2021 10:22 1 KB JMyers to previous
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 2 KB JMyers to previous | to last
3 26-Nov-2021 10:22 803 bytes JMyers to previous | to last
2 26-Nov-2021 10:22 688 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 changed 2 lines
!!!Alias: [IVEMT]
(INF_CV_MILITARIES)
[{TableOfContents }]
!!!MILITARY RECORD INTERFACE FILE
At line 4 changed one line
The INF_CV_MILITARIES table is used to import employee military records into the software data structures. This table is used for employees who have performed prior military service or have current military commitments.
The Military Record Interface File screen is used to import military records into the software data structures.
At line 6 changed 18 lines
Tables loaded: [P2K_HR_MILITARIES]
!!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.
|[PERSON_CODE]|Varchar2(16)|Y|Validation: Must be a valid [PERSON_CODE] already defined on the [P2K_HR_IDENTITIES] table
|[MILITARY_BRANCH]|Varchar2(30)|Y|Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_MILITARY_BRANCH]
|[ENLISTED_DATE]|Date()|Y|Validation: Must be a valid date.
|[DESCRIPTION]|Varchar2(50)| |
|[MILITARY_STATUS]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_MILITARY_STATUS]
|[MILITARY_RANK]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description from [X_MILITARY_RANK]
|[DISCHARGED_DATE]|Date()| |Validation: Must be a valid date
|[DISCHARGE_TYPE]|Varchar2(30)| |Validation: Must be either a valid lexicon code, or a valid lexicon description [X_MILITARY_DISCH_TYPE]
|[SECURITY_CLEARANCE]|Varchar2(30)| | Validation: Must be either a valid lexicon code, or a valid lexicon description [X_SECURITY_CLEARANCE]
|[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.
Contacts Interface File data is maintained on the [INF_CV_MILITARIES] table.
At line 8 added 10 lines
;[ID|ID]:This field uniquely identifies the military record within the data base.
;[Person Code|PERSON_CODE]:This field identifies the employee for whom the military records are being imported.
;[Military Branch|MILITARY_BRANCH]:This field displays the branch of the military in which an employee has service.
;[Enlisted As Of|ENLISTED_DATE]:This field shows the date the employee was enlisted or commissioned.
;[Description|DESCRIPTION]:Description is used to specify rank, occupation or specialization information for the employee.
;[Status|MILITARY_STATUS]:This field indicates current military status (i.e. Active Reserve).
;[Rank|MILITARY_RANK]:This field indicates whether the employee was enlisted or commissioned in a service branch.
;[Discharged On|DISCHARGED_DATE]:This is the date the employee was discharged.
;[Discharge Type|DISCHARGE_TYPE]:This field displays the type of discharge from military service the employee received.
;[Security Clearance|SECURITY_CLEARANCE]:This field displays the level of security clearance the employee received.
At line 26 removed one line
[{If var='loginstatus' contains 'authenticated'
At line 29 changed 2 lines
![Discussion|Edit:Internal.INF_CV_MILITARIES]
[{InsertPage page='Internal.INF_CV_MILITARIES' default='Click to create a new discussion page'}]
![Notes|Edit:Internal.IVEMT]
[{InsertPage page='Internal.IVEMT' default='Click to create a new notes page'}]
At line 32 removed one line
}]