PER_PERIODS_OF_SERVICE
This table stores all information related to the person?s Work Relationships. An Work Relationship denotes a formal relationship between a person and a legal employer. Therefore, this table will hold information for employees and contingent workers. Current design allows for a person to have multiple active ?periods of service? as long as they are for different legal entities. This is not Effective Dated.
Details
-
Schema: FUSION
-
Object owner: PER
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PER_PERIODS_OF_SERVICE_PK |
PERIOD_OF_SERVICE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| PERIOD_OF_SERVICE_ID | NUMBER | 18 | Yes | System generated primary key. | Active | ||
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS. | Active | ||
| TERMINATION_ACCEPTED_PERSON_ID | NUMBER | 18 | Person who accepted or authorized employee termination. Foreign key to PER_PERSONS. | Active | |||
| PERSON_ID | NUMBER | 18 | Yes | Foreign key to PER_PERSONS. | Active | ||
| DATE_START | DATE | Yes | Start date of the period of employment. | Active | |||
| ACCEPTED_TERMINATION_DATE | DATE | Date when termination of employment was accepted. | Active | ||||
| ACTUAL_TERMINATION_DATE | DATE | Actual date of termination of employment. | Active | ||||
| NOTIFIED_TERMINATION_DATE | DATE | Date when the termination of employment was noted. | Active | ||||
| PROJECTED_TERMINATION_DATE | DATE | Projected employment termination date. | Active | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that 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. | Active | ||
| ADJUSTED_SVC_DATE | DATE | Adjusted Service Date. For example, a rehire that was part of an acquisition, all of his plans might use original hire date if rehired within 90 days of termination except a 401k plan which might use adjusted service date which was originally populated upon acquisition. | Active | ||||
| PDS_INFORMATION_CATEGORY | VARCHAR2 | 30 | Developer Descriptive Flexfield: structure definition of the user descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION1 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION2 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION3 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION4 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION5 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION6 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION7 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION8 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION9 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION10 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION11 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION12 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION13 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION14 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION15 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION16 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION17 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION18 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION19 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION20 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION21 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION22 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION23 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION24 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION25 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION26 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION27 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION28 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION29 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION30 | VARCHAR2 | 150 | Developer Descriptive Flexfield: segment of the developer descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | Active | ||
| PDS_INFORMATION_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER13 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER14 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER15 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER16 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER17 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER18 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER19 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_NUMBER20 | NUMBER | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE1 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE2 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE3 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE4 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE5 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE6 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE7 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE8 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE9 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE10 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE11 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE12 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE13 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE14 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| PDS_INFORMATION_DATE15 | DATE | Descriptive Flexfield: segment of the descriptive flexfield. | Work Relationship Legislative Information (PER_PPS_LEG_DDF) | ||||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | Active | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER13 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER14 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER15 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER16 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER17 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER18 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER19 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_NUMBER20 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE13 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE14 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| ATTRIBUTE_DATE15 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Work Relationship Attributes (PER_PPS_DF) | ||||
| DATE_EMPLOYEE_DATA_VERIFIED | DATE | Date when the employee last verified the data. | Active | ||||
| FAST_PATH_EMPLOYEE | VARCHAR2 | 30 | Yes | Accepts values of ?Yes? or ?No?. | Active | ||
| LAST_WORKING_DATE | DATE | Last Date Worked (for terminated workers). | Active | ||||
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Represents Legal Entity. | Active | ||
| LEGISLATION_CODE | VARCHAR2 | 150 | Yes | Legislation code derived from Legal Entity. | Active | ||
| ON_MILITARY_SERVICE | VARCHAR2 | 30 | Yes | Accepts Yes or No values. If Yes, employee is also on military service. | Active | ||
| ORIGINAL_DATE_OF_HIRE | DATE | Original date of hire. | Active | ||||
| PERIOD_TYPE | VARCHAR2 | 30 | Yes | Determines whether it is a period of service for an Employee, or Contingent worker: ?E? or ?C?, or ?N?: non-worker. | Active | ||
| PRIMARY_FLAG | VARCHAR2 | 30 | Yes | Accepts Yes or No values. If Yes, this employment period is considered the primary for the Legal Entity. | Active | ||
| REHIRE_AUTHORIZOR | VARCHAR2 | 30 | Obsolete | Active | |||
| REHIRE_REASON | VARCHAR2 | 60 | If rehire recommendation is ?yes?, then reason from recommending person is tracked via this field. | Active | |||
| REHIRE_RECOMMENDATION | VARCHAR2 | 30 | Yes | Accepts Yes or No values. If Yes, person is recommended for re-hiring. | Active | ||
| WORKER_NUMBER | VARCHAR2 | 30 | Uniquely identifies an employee or contingent worker. Can be system-generated or manually populated. | Active | |||
| ACTION_OCCURRENCE_ID | NUMBER | 18 | Foreign Key to PER_ACTION_OCCURRENCES. | ||||
| COMMENTS | VARCHAR2 | 1000 | This stores a comment associated with termination of work relationship. | ||||
| WORKER_COMMENTS | VARCHAR2 | 1000 | This stores a worker comment associated with the Resignation Process. | ||||
| REHIRE_AUTHORIZER_PERSON_ID | NUMBER | 18 | Foreign Key to PER_PERSONS. Represents the person who recommends the worker for rehire. | ||||
| REVOKE_USER_ACCESS | VARCHAR2 | 30 | This stores user?s option of revoking user access on Termination. Values accepted are ?I? for Immediately or ?A? for After termination | ||||
| READY_TO_CONVERT | VARCHAR2 | 10 | Column to use to convert pending worker to employee based on flag |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PER_PERIODS_OF_SERVICE_FK1 | Non Unique | Default | BUSINESS_GROUP_ID | Active |
| PER_PERIODS_OF_SERVICE_FK2 | Non Unique | Default | REHIRE_AUTHORIZER_PERSON_ID | |
| PER_PERIODS_OF_SERVICE_N2 | Non Unique | Default | TERMINATION_ACCEPTED_PERSON_ID | Active |
| PER_PERIODS_OF_SERVICE_N3 | Non Unique | Default | PERSON_ID, PERIOD_TYPE, LEGAL_ENTITY_ID | Active |
| PER_PERIODS_OF_SERVICE_PK | Unique | Default | PERIOD_OF_SERVICE_ID |