GPBR_H07_VW(SQL View) |
Index Back |
---|---|
Homolognet Temporary View 07Homolognet Temporary View 07. |
SELECT PROCESS_INSTANCE , LAST_HIRE_DT , TERMINATION_DT , EMPLID , EMPL_RCD , EFFDT , EFFSEQ , GPBR_DSR_UNITS , PIN_NET_VAL FROM PS_GPBR_H02_TMP |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | LAST_HIRE_DT | Date(10) | DATE | Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD. |
3 | TERMINATION_DT | Date(10) | DATE | Termination Date |
4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
5 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
7 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
8 | GPBR_DSR_UNITS | Number(1,0) | SMALLINT NOT NULL | Homolognet DSR Units Entitlement related the Termination Month, except in the last week. |
9 | PIN_NET_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Net Pay Value |