GP_PAYGROUPCAL_IDGP_CAL_RUND_VW(SQL View) |
Index Back |
|---|---|
CalRunDtl view for PIView used in PI pages to determine whether or not Triggers should be generated |
| SELECT GP_PAYGROUP ,CAL_ID ,CAL_IDNT_TS FROM PS_GP_CAL_RUN_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 3 | CAL_IDNT_TS | DateTime(26) | TIMESTAMP | Calendar Identify Timestamp |