EMPLIDEMPL_RCDEMPL_CLASSCAL_RUN_IDGP_PAYGROUPCAL_IDORIG_CAL_RUN_IDRSLT_SEG_NUMGPBR_DC_RENU_VW(SQL View) |
Index Back |
|---|---|
Receipt number viewReceipt number view |
| SELECT EMPLID , EMPL_RCD , EMPL_CLASS , CAL_RUN_ID , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , PERIOD_END_DT , RUN_TYPE , PAYMENT_DT , NATIONAL_ID , DENSE_RANK() OVER (partition BY emplid , period_end_dt ORDER BY EMPLID , PERIOD_END_DT , RUN_TYPE , PAYMENT_DT) AS NUM_RECIBO FROM PS_GPBR_REC_NUM_WA A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EMPL_CLASS |
Character(3) | VARCHAR2(3) NOT NULL | Employee Classification |
| 4 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 5 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |
| 7 | ORIG_CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Original Calendar Group ID |
| 8 | RSLT_SEG_NUM |
Number(4,0) | SMALLINT NOT NULL | Result Segment Number |
| 9 | PERIOD_END_DT | Date(10) | DATE | Period End Date |
| 10 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 11 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 12 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 13 | KEY_SIGN_NUM_01 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This is used as a flexible / configurable signed number field (SEPA/Financial Gateway) |