PAY_POPULATION_RANGES
This table contains ranges of people to be inserted as assignment actions, used to manage parallel running of payroll processes.
Details
-
Schema: FUSION
-
Object owner: PAY
-
Object type: TABLE
-
Tablespace: SYSTEM
Primary Key
| Name | Columns |
|---|---|
|
PAY_POPULATION_RANGES_PK |
PAYROLL_ACTION_ID, CHUNK_NUMBER, SOURCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYROLL_ACTION_ID | NUMBER | 18 | Yes | PAYROLL_ACTION_ID | |
| CHUNK_NUMBER | NUMBER | 18 | Yes | CHUNK_NUMBER | |
| RANGE_STATUS | VARCHAR2 | 1 | Yes | RANGE_STATUS | |
| RAND_CHUNK_NUMBER | NUMBER | 18 | RAND_CHUNK_NUMBER | ||
| PERSON_ID | NUMBER | 18 | PERSON_ID | ||
| SOURCE_ID | NUMBER | 18 | Yes | SOURCE_ID | |
| SOURCE_TYPE | VARCHAR2 | 30 | SOURCE_TYPE | ||
| ENTERPRISE_ID | NUMBER | 18 | Yes | Foreign key to PER_ENTERPRISES. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PAY_POPULATION_RANGES_N1 | Non Unique | Default | PAYROLL_ACTION_ID, RANGE_STATUS |
| PAY_POPULATION_RANGES_PK | Unique | Default | PAYROLL_ACTION_ID, CHUNK_NUMBER, SOURCE_ID |
| PAY_POPULATION_RANGES_UK1 | Unique | Default | PAYROLL_ACTION_ID, CHUNK_NUMBER, SOURCE_ID, PERSON_ID |