A241
Roster Planning
Properties Sources: prospetto
- Code
A241- Description
- Roster Planning
- Web opening
NV- Type flags
- Input
- Groups
- A24
Structure
Sources: prospetto_xml
Form parameters
3
▾
Form filters
4 dims
▾
Planning effectif
Template00 · 3 matrices
Position Planning
CPM
Cols
DEST1
1
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| 010 | › | $DEST1_010_P | param |
PERIODO
1
CONTO
15
TIP
2
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| › | TIP_O | fixed | ||
| › | TIP_DES | fixed |
Employee Planning
CPM
Cols
DEST1
1
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| 010 | › | $DEST1_010_P | param |
PERIODO
12
▾
CONTO
16
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| $ | › | ST_400 | fixed | |
| $ | › | ST_410 | fixed | |
| $ | › | ST_420 | fixed | |
| $ | › | ST_612 | fixed | |
| $ | › | ST_450 | fixed | |
| $ | › | ST_475 | fixed | |
| $ | › | ST_460 | fixed | |
| $ | › | ST_642 | fixed | |
| $ | › | ST_495 | fixed | |
| $ | › | ST_500 | fixed | |
| $ | › | ST_680 | fixed | |
| $ | › | ST_685 | fixed | |
| $ | › | ST_675 | fixed | |
| $ | › | ST_457 | fixed | |
| $ | › | 60010 | fixed | |
| $ | › | ST_540 | fixed |
TIP
2
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| › | TIP_DES | fixed | ||
| › | TIP_O | fixed |
Rate of Pay
CPM
Hypoth
Template01 · 4 matrices
Rate of Pay
CPM
Filters
TIP
1
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| › | TIP_O | fixed |
Rows
Benefits
CPM
Rates & Caps
CPM
Paychecks
CPM
Filters
TIP
1
| Hierarchy / FST | Item | Type | TGKML | |
|---|---|---|---|---|
| › | TIP_O | fixed |
Rows
PERIODO
12
Queries 8
Sources: prospetto_xml
ENTITY
SQL
▾
Query07
SELECT DESC_azienda0
FROM azienda
Medical
SQL
▾
Query06
SELECT 'Ind. Basic' as Medical union
SELECT 'Ind. Premium' as Medical union
SELECT 'Fam. Basic' as Medical union
SELECT 'Fam. Premium' as Medical
Dental
SQL
▾
Query05
SELECT 'Ind. Basic' as Dental union
SELECT 'Ind. Premium' as Dental union
SELECT 'Fam. Basic' as Dental union
SELECT 'Fam. Premium' as Dental
Retire
SQL
▾
Query04
SELECT 'Plan 1' as Retire union
SELECT 'Plan 2' as Retire union
SELECT 'Plan 3' as Retire union
SELECT 'Plan 4' as Retire
order by Retire
Status
SQL
▾
Query03
SELECT 'Active' as Status union
SELECT 'Paid Leave' as Status union
SELECT 'Terminated' as Status union
SELECT 'Unpaid Leave' as Status union
SELECT 'Transfer' as Status
Type
SQL
▾
Query02
Select 'Hourly-Based' as Type union
Select 'Salary-Based' as Type union
Select 'Contracted' as Type
Title
SQL
▾
Query01
SELECT 'Senior VP' as title union
SELECT 'Vice Pres.' as title union
SELECT 'Director' as title union
SELECT 'Manager' as title union
SELECT 'Senior Associate' as title union
SELECT 'Associate' as title union
SELECT 'Assistant' as title union
SELECT 'Partner' as title union
SELECT 'Attorney' as title
Month
SQL
▾
Query00
select DESC_PERIODO0 from periodo
order by cod_periodo