EMPLIDPrompt Table: PERSON
DEPENDENT_IDPrompt Table: DEPENDENT_VW
B=Beneficiary
C=COBRA Dependent Only
D=Dependent
E=QDRO Estate
N=None
O=Both
Q=QDRO Representative - Employee
R=QDRO Representative -Recipient
DEPENDENT(SQL View) |
Index Back |
|---|---|
EE Dependents-Internat AssignDEPENDENT is a view that selects an employee's dependents from DEPENDENT_BENEF where the person is a dependent or a beneficiary. This view is used in International Assignment. |
| SELECT A.Emplid ,A.Dependent_Benef ,A.Name ,A.Relationship ,A.Dep_Benef_Type FROM PS_DEPENDENT_BENEF A WHERE A.Dep_Benef_Type <> 'C' |
| # | 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_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent ID
Prompt Table: DEPENDENT_VW |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | RELATIONSHIP | Character(2) | VARCHAR2(2) NOT NULL | Relationship to Employee |
| 5 | DEP_BENEF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Dependent Beneficiary Type
B=Beneficiary C=COBRA Dependent Only D=Dependent E=QDRO Estate N=None O=Both Q=QDRO Representative - Employee R=QDRO Representative -Recipient |