GPAR_DEP_BEN_VW(SQL View) |
Index Back |
|---|---|
Relationship ARGUsed into GP process when calculate all discount for relationship |
| SELECT DISTINCT F.GP_PAYGROUP , F.CAL_ID , A.EMPLID , A.DEPENDENT_BENEF , D.EFFDT , D.RELATIONSHIP , D.MAR_STATUS , A.BIRTHDATE , D.DISABLED , A.DT_OF_DEATH FROM PS_DEP_BEN A , PS_DEP_BEN_EFF D , PS_GP_PYE_SEG_STAT F WHERE D.EMPLID = A.EMPLID AND D.DEPENDENT_BENEF = A.DEPENDENT_BENEF AND D.EMPLID = F.EMPLID AND (D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEP_BEN_EFF D1 WHERE D1.EMPLID = D.EMPLID AND D1.DEPENDENT_BENEF = D.DEPENDENT_BENEF AND D1.EFFDT <= F.SEG_END_DT)) |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
| 7 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |
| 8 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 9 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a dependent is a disabled. |
| 10 | DT_OF_DEATH | Date(10) | DATE | Date of Death |