PJC_PAYROLL_PER_ASSIGNMENT_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

RULE_HDR_ID PERSON_ID ASSIGNMENT_ID START_DATE_ACTIVE END_DATE_ACTIVE TYPE TIME_CARD_DISTR_FLAG LEGISLATIVE_DATA_GROUP_ID SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SEGMENT11 SEGMENT12 SEGMENT13 SEGMENT14 SEGMENT15 SEGMENT16 SEGMENT17 SEGMENT18 SEGMENT19 SEGMENT20 SEGMENT21 SEGMENT22 SEGMENT23 SEGMENT24 SEGMENT25 SEGMENT26 SEGMENT27 SEGMENT28 SEGMENT29 SEGMENT30

Query

SQL_Statement

SELECT rules.rule_hdr_id, rules.person_id, rules.assignment_id, rules.start_date_active, rules.end_date_active, rules.type, 'N' as TIME_CARD_DISTR_FLAG, hdr.legislative_data_group_id, hcm_acct.segment1, hcm_acct.segment2, hcm_acct.segment3, hcm_acct.segment4, hcm_acct.segment5, hcm_acct.segment6, hcm_acct.segment7, hcm_acct.segment8, hcm_acct.segment9, hcm_acct.segment10, hcm_acct.segment11, hcm_acct.segment12, hcm_acct.segment13, hcm_acct.segment14, hcm_acct.segment15, hcm_acct.segment16, hcm_acct.segment17, hcm_acct.segment18, hcm_acct.segment19, hcm_acct.segment20, hcm_acct.segment21, hcm_acct.segment22, hcm_acct.segment23, hcm_acct.segment24, hcm_acct.segment25, hcm_acct.segment26, hcm_acct.segment27, hcm_acct.segment28, hcm_acct.segment29, hcm_acct.segment30 FROM pjc_alloc_rules_all rules, pjc_rules_hdr hdr, ( SELECT alloc.source_id, alloc.cost_allocation_id, alloc.legislative_data_group_id, alloc.cost_allocation_record_id, acct.cost_alloc_account_id, acct.segment1, acct.segment2, acct.segment3, acct.segment4, acct.segment5, acct.segment6, acct.segment7, acct.segment8, acct.segment9, acct.segment10, acct.segment11, acct.segment12, acct.segment13, acct.segment14, acct.segment15, acct.segment16, acct.segment17, acct.segment18, acct.segment19, acct.segment20, acct.segment21, acct.segment22, acct.segment23, acct.segment24, acct.segment25, acct.segment26, acct.segment27, acct.segment28, acct.segment29, acct.segment30 FROM pay_cost_allocations_f alloc, pay_cost_alloc_accounts acct WHERE alloc.cost_allocation_record_id = acct.cost_allocation_record_id AND alloc.source_type = 'PPMLD' ) hcm_acct WHERE rules.ld_version_status = 'A' and rules.rule_hdr_id = hdr.rule_hdr_id and nvl(rules.person_id, 1) = nvl(hdr.person_id, 1) and nvl(rules.element_type_id, 1) = nvl(hdr.element_type_id, 1) and nvl(rules.assignment_id, 1) = nvl(hdr.assignment_id, 1) AND hdr.type IN ( 'ASE', 'ASG', 'KFF' ) AND hdr.rule_hdr_id = hcm_acct.source_id (+)