GPMY_DEP_PYE_VW(SQL View) |
Index Back |
|---|---|
View of Payee DependentsUsed by GP MYS - View of Payee Dependents |
| SELECT PS_DEPENDENT_BENEF.EMPLID ,PS_DEPENDENT_BENEF.DEPENDENT_BENEF ,RELATIONSHIP ,FULLTM_STUDENT_MYS ,FULLTM_STU_OUT_MYS ,DISABLED ,MAR_STATUS ,BIRTHDATE FROM PS_DEPENDENT_BENEF ,PS_GPMY_DEP_BNF_VW WHERE PS_DEPENDENT_BENEF.EMPLID = PS_GPMY_DEP_BNF_VW.EMPLID(+) AND PS_DEPENDENT_BENEF.DEPENDENT_BENEF = PS_GPMY_DEP_BNF_VW.DEPENDENT_BENEF(+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | DEPENDENT_BENEF |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Default Value: 01 |
| 3 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
| 4 | FULLTM_STUDENT_MYS | Character(1) | VARCHAR2(1) NOT NULL |
Full Time Student
N=Outside Malaysia Y=Within Malaysia Y/N Table Edit |
| 5 | FULLTM_STU_OUT_MYS | Character(1) | VARCHAR2(1) NOT NULL | Full Time Student |
| 6 | DISABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a dependent is a disabled.
Y/N Table Edit Default Value: N |
| 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 Default Value: S |
| 8 | BIRTHDATE | Date(10) | DATE | Date of Birth |