GPBR_ACTER_VW(SQL View) |
Index Back |
|---|---|
Accumulators with Co. or EstabAccumulators with Company or Estabid on user fields |
| SELECT AC.PIN_NUM , AC.ACM_PRD_OPTN , AC.PIN_USER_KEY1_NUM , AC.PIN_USER_KEY2_NUM , AC.PIN_USER_KEY3_NUM , AC.PIN_USER_KEY4_NUM , AC.PIN_USER_KEY5_NUM , AC.PIN_USER_KEY6_NUM FROM PS_GP_ACCUMULATOR AC , PS_GP_PIN PIN WHERE (AC.PIN_USER_KEY1_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('COMPANY', 'ESTABID')) OR AC.PIN_USER_KEY2_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('COMPANY', 'ESTABID')) OR AC.PIN_USER_KEY3_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('COMPANY', 'ESTABID')) OR AC.PIN_USER_KEY4_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('COMPANY', 'ESTABID')) OR AC.PIN_USER_KEY5_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('COMPANY', 'ESTABID')) OR AC.PIN_USER_KEY6_NUM IN ( SELECT PIN_NUM FROM PS_GP_PIN WHERE PIN_NM IN ('COMPANY', 'ESTABID')) ) AND AC.PIN_NUM = PIN.PIN_NUM AND PIN.COUNTRY = 'BRA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | ACM_PRD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Accumulator Period
1=Segment 2=Calendar Period 3=Month to Date 4=Quarter to Date 5=Year to Date 6=Custom Period |
| 3 | PIN_USER_KEY1_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD1 |
| 4 | PIN_USER_KEY2_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD2 |
| 5 | PIN_USER_KEY3_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD3 |
| 6 | PIN_USER_KEY4_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD4 |
| 7 | PIN_USER_KEY5_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD5 |
| 8 | PIN_USER_KEY6_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD6 |