Emp/App Personnel Codes
The Emp/App Personnel Codes file is a multi-purpose file containing the following records. Employee and applicant certification Employee company property Employee and applicant education Employee benefits Employee and applicant relocation Employee and applicant skill Records in this file are differentiated by the values in the EPC-TYPE and EPC-EMP-APP fields as described below. Many of the fields in this file have different meanings depending on the type of record. This file is maintained by the Personnel system.
REFERENCED BY
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EPC-COMPANY Element: Company Hr | Numeric 4 Contains the company number represents an established company. |
|
||||||||||||||||
EPC-TYPE Element: Type | Alpha 2 This field indicates the kind of information stored in the record. BN = Benefit Codes CE = Certifications CN = Contracts CP = Company Property ED = Education RL = Relocation SK = Skills AB = Ability KN = Knowledge OA = Other Attributes LC = License |
|
||||||||||||||||
EPC-EMP-APP Element: Emp App | Numeric 1 This field contains the employee applicant indicator. 0 = Employee 1 = Applicant |
|||||||||||||||||
EPC-EMPLOYEE Element: Employee | Numeric 9 Contains the employee Number |
|||||||||||||||||
EPC-CODE Element: Code | Alpha 10 This is the name of the code being described. All codes must be valid in PCODES. Valid values are: ED = Education Degree. CP = Property. SK = Skill. CE = Certification. RL = Relocation. BN = Benefit. |
|
||||||||||||||||
EPC-SUBJECT Element: Subject | Alpha 10 This field is only filled on "ED" (education records) and contains the subject for the degree. The subject code must be valid in PCODES. |
|
||||||||||||||||
EPC-SEQ-NBR Element: Seq Nbr | Numeric 4 This field is filled for "CP" (property), "ED" (education Degree), and "SK" (skill) records only and is automatically assigned. |
|||||||||||||||||
EPC-DATE-ACQUIRED Element: Date Acquired | Numeric 8 (yyyymmdd) Contains the following: - the date the certificate was acquired, - the date skill was acquired, or - the date property was issued. This field is used only for CE (Certifications), CP (Company Property), and SK (Skill). |
|
||||||||||||||||
EPC-RENEW-DATE Element: Renew Date | Numeric 8 (yyyymmdd) This field contains the following information: CE = Certificate renewal date. CP = Anticipated return date. ED = Degree completion date. BN = Zeroes. RL = Zeroes. SK = Date skill was last used. |
|
||||||||||||||||
EPC-PER-RATING Element: Per Rating | Signed 5.2 This is a user-defined field and is only filled for types "ED" (education degree) and "SK" (skill). |
|
||||||||||||||||
EPC-INSTRUCTOR Element: Instructor | Alpha 10 This field contains the following information: CE = Spaces. CP = Spaces. ED = Education Institution. BN = Spaces. RL = Spaces. SK = Skill Instructor. |
|
||||||||||||||||
EPC-CO-SPONSORED Element: Co Sponsored | Alpha 1 This field is filled for types "CE" (certification), "ED" (education degree), and "SK" (skill). Y = Yes N = No |
|
||||||||||||||||
EPC-IN-PRO-FLAG Element: In Pro Flag | Alpha 1 This field can contain the following information: CE = Spaces. CP = Spaces. ED = Education in process. BN = Dependent coverage. RL = Relocation status. SK = Space. (R - Requests transfer W - Will transfer N - Will not transfer) Y = Yes N = No |
|
||||||||||||||||
EPC-LIC-NUMBER Element: Lic Number | Alpha 20 This field is filled only for "CE" (certification) and contains the certification license number. |
|
||||||||||||||||
EPC-COST Element: Cost | Signed 11.2 This field is filled only for "CE" (certification) and contains the cost of obtaining the certification. |
|
||||||||||||||||
EPC-RENEWAL-CODE Element: Renewal Code | Alpha 2 This field is only filled for "CE" (certification). 2Y = 2 Years 3Y = 3 Years 4Y = 4 Years 5Y = 5 Years 6Y = 6 Years 7Y = 7 Years 8Y = 8 Years 9Y = 9 Years AN = Annual QT = Quarterly SA = Semi-annual |
|
||||||||||||||||
EPC-COMPONENT Element: Component | Numeric 4 This field is only filled for "CP" (certification) and gives the component number of the property issued. |
|
||||||||||||||||
EPC-PROP-VALUE Element: Prop Value | Signed 15.2 This field is only filled for "CP" (property) and gives the value of the company property. |
|
||||||||||||||||
EPC-PA-ASSET-NBR Element: Pa Asset Nbr | Alpha 9 (Lower Case) Contains the asset number of the property issued. |
|
||||||||||||||||
EPC-DATE-RETURNED Element: Date Returned | Numeric 8 (yyyymmdd) This field is only filled for "CP" (property) and is the date the company property was returned. |
|
||||||||||||||||
EPC-VERIFIED-FLAG Element: Verified Flag | Alpha 1 This field is only filled for "ED" (education degree) for an applicant's record. It indicates if an applicant's education degree has been verified. N = No Y = Yes |
|
||||||||||||||||
EPC-PRIORITY-CODE Element: Priority Code | Numeric 1 This field is only filled for "RL" (relocation) and with the statuses of "R" (requests transfer) or "W" (will transfer). |
|
||||||||||||||||
EPC-SKILL-SOURCE Element: Skill Source | Alpha 10 This field is only filled for "SK" (Skill). The skill source must be valid in PCODES. |
|
||||||||||||||||
EPC-PROFIC-LEVEL Element: Profic Level | Alpha 10 Contains the proficiency level of the skill. |
|
||||||||||||||||
EPC-OBJ-ID Element: Obj Id | Numeric 12 This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems. |
|
||||||||||||||||
EPC-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the currency in which the cost is recorded. |
|
||||||||||||||||
EPC-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||||||
EPC-BASE-AMOUNT Element: Base Amt | Signed 15.2 Contains the amount in the company's base currency. |
|
||||||||||||||||
EPC-BASE-CURRENCY Element: Base Currency | Alpha 5 The company base currency. |
|
||||||||||||||||
EPC-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||||||||||||||
EPC-DATE-STAMP Element: Date Stamp | Numeric 8 (yyyymmdd) This field contains the server date (month, date, and year) of the last change to this record. |
|
||||||||||||||||
EPC-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||||||||||||||
EPC-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||||||||||||||
EPC-STATE Element: State | Alpha 2 This field contains the two-character state code of the address. |
|
||||||||||||||||
EPC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field displays the description. |
|
||||||||||||||||
EPC-WF-VERIFY Element: Wf Verify | Derived This is a derived field. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EPCSET1 |
COMPANY TYPE EMP-APP EMPLOYEE CODE SUBJECT SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
EPCSET2 |
COMPANY TYPE EMP-APP CODE EMPLOYEE SUBJECT SEQ-NBR |
|
|||||||||||||||||||||||||||||||||||||||||||||||
EPCSET3 |
COMPANY EMP-APP EMPLOYEE TYPE CODE SUBJECT SEQ-NBR* |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
EPCSET4 |
COMPANY TYPE EMP-APP EMPLOYEE SUBJECT CODE SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
EPCSET5 |
COMPANY TYPE EMP-APP EMPLOYEE RENEW-DATE CODE SUBJECT SEQ-NBR |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
EPCSET6 |
OBJ-ID COMPANY EMP-APP EMPLOYEE TYPE CODE |
|
| ||||||||||||||||||||||||||||||||||||||||||||||
EPCSET7 |
COMPANY EMP-APP EMPLOYEE TYPE CODE DATE-ACQUIRED* SUBJECT SEQ-NBR |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Applicant | APPLICANT |
Required
| ||||||||||||||||||
Base Currency | CUCODES |
Required
| ||||||||||||||||||
Company | PRSYSTEM |
Required
| ||||||||||||||||||
Contract | PCODES |
Required
| ||||||||||||||||||
Currency | CUCODES |
Required
| ||||||||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||||||||
Hr Code | PCODES |
Required
| ||||||||||||||||||
Institution | PCODES |
Required
| ||||||||||||||||||
Paemployee | PAEMPLOYEE |
Required
| ||||||||||||||||||
Skill Source | PCODES |
Required
| ||||||||||||||||||
Subject | PCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Bn Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Ce Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Course Skills | PAATTRIB |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Cp Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Ed Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Rl Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Sk Comments | PACOMMENTS |
Delete Cascades
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Track Cert | PATRACK |
|
All trademarks and registered trademarks are the property of their
respective owners.