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

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
3 26-Nov-2021 10:22 962 bytes rforbes to previous
2 26-Nov-2021 10:22 997 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links
IVSPA
IVSPA

Version management

Difference between version and

At line 1 changed 3 lines
!!!Alias: [IVSPA]
(INF_CV_PERSONNELACTIONS)
\\
!!!PERSONAL ACTION INTERFACE FILE
At line 5 changed one line
Reviews
The Personal Action Interface File screen is used to import personal action records into the software data structures.
At line 7 changed 29 lines
!!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|
|[PA_NUMBER]|Number(10)|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)| |
|[HIRE_DATE]|Date()| |
|[PERSON_CODE]|Varchar2(16)|Y|
|[PA_STATUS]|Varchar2(30)|Y|
|[CHANGE_CODE]|Varchar2(16)|Y|
|[PA_EFFECTIVE_DATE]|Date()|Y|
|[ASSIGNMENT_CODE]|Varchar2(16)|Y|
|[ASSIGNMENT_START_DATE]|Date()|Y|
|[REVIEW_NUMBER]|Number(10)|Y|
|[PA_TYPE_CODE]|Varchar2(16)|Y|
|[APPROVED]|Varchar2(4)| |
|[DESCRIPTION]|Varchar2(50)| |
|[UPDATE_FUTURE_RECORDS]|Varchar2(4)| |
|[CASCADE_CHANGE_REASON]|Varchar2(4)| |
|[TABLE_ALIAS]|Varchar2(16)| |
|[TABLE_NAME]|Varchar2(30)| |
|[COLUMN_NAME]|Varchar2(30)| |
|[PA_CHANGE_STATUS]|Varchar2(30)| |
|[PA_TYPE_OF_VALUE]|Varchar2(50)| |
|[REFERENCE_ID]|Number(10)| |
|[COLUMN_SEQUENCE]|Number(5)| |
|[PA_OLD_VALUE]|Varchar2(2000)| |
|[PA_NEW_VALUE]|Varchar2(2000)| |
Personal Action Interface File data is maintained on the [INF_CV_PERSONNELACTIONS] table.
At line 7 added one line
;[ID|ID]:This field identifies the personal action record within the data base.
At line 9 added 25 lines
;[|ENTITY_CODE]:
;[|PA_NUMBER]:
;[|EMPLOYMENT_TYPE]:
;[|HIRE_DATE]:
;[|PERSON_CODE]:
;[|PA_STATUS]:
;[|CHANGE_CODE]:
;[|PA_EFFECTIVE_DATE]:
;[|ASSIGNMENT_CODE]:
;[|ASSIGNMENT_START_DATE]:
;[|REVIEW_NUMBER]:
;[|PA_TYPE_CODE]:
;[|APPROVED]:
;[|DESCRIPTION]:
;[|UPDATE_FUTURE_RECORDS]:
;[|CASCADE_CHANGE_REASON]:
;[|TABLE_ALIAS]:
;[|TABLE_NAME]:
;[|COLUMN_NAME]:
;[|PA_CHANGE_STATUS]:
;[|PA_TYPE_OF_VALUE]:
;[|REFERENCE_ID]:
;[|COLUMN_SEQUENCE]:
;[|PA_OLD_VALUE]:
;[|PA_NEW_VALUE]:
At line 39 removed one line
[{If var='loginstatus' contains 'authenticated'
At line 42 changed 4 lines
![Discussion|Edit:Internal.IVSPA]
[{InsertPage page='Internal.IVSPA' default='Click to create a new discussion page'}]
}]
![Notes|Edit:Internal.IVSPA]
[{InsertPage page='Internal.IVSPA' default='Click to create a new notes page'}]
This page (revision-3) was last changed on 26-Nov-2021 10:22 by rforbesTop