EMPLIDPrompt Table: PERS_SRCH_GBL
COURT_DOC_ID01=default
Prompt Table: DEP_BENEF_VW
PA_DRO_DOC_VW(SQL View) |
Index Back |
|---|---|
DRO Data (non-cancelled)This is an employee table for QDRO. |
| SELECT a.emplid , a.court_doc_id , a.dependent_benef , b.name FROM ps_pa_drodat a , PS_DEPENDENT_VW b WHERE a.dro_cancel_dt IS NULL AND 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: PERS_SRCH_GBL |
| 2 | COURT_DOC_ID |
Character(25) | VARCHAR2(25) NOT NULL | Court Document ID |
| 3 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEP_BENEF_VW |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |