GPMY_DEP_PYE_VW(SQL View) |
Index Back |
|---|---|
View of Payee DependentsUsed by GP MYS - View of Payee Dependents |
| SELECT A.EMPLID ,A.DEPENDENT_BENEF ,A.RELATIONSHIP ,B.FULLTM_STUDENT_MYS ,B.FULLTM_STU_OUT_MYS ,B.FULLTM_STDNT_MRT ,A.DISABLED ,A.MAR_STATUS ,A.BIRTHDATE FROM PS_DEPENDENT_BENEF A ,PS_GPMY_DEP_BNF_VW B WHERE A.EMPLID = B.EMPLID(+) AND A.DEPENDENT_BENEF = B.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 | FULLTM_STDNT_MRT | Character(1) | VARCHAR2(1) NOT NULL |
This field stored the value either Yes or No based for Malaysian Student Marticutation/Certification
N=Outside Malaysia Matriculation Y=Within Malaysia Marticulation |
| 7 | 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 |
| 8 | 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 |
| 9 | BIRTHDATE | Date(10) | DATE | Date of Birth |