EMPLIDQDRO_IDBENEFIT_PLANCOMMENT_DTDefault Value: %date
PA_COMMENT_SRC0=
1=Copied from DRO Panel
2=From Old Communications Panel
3=From Old Status Panel
Default Value: 0
Default Value: PA_DRODAT.COMMENTS
PA_QDROCOM(SQL Table) |
Index Back |
|---|---|
QDRO Related CommentsThis is an employee table for QDRO. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | QDRO_ID |
Character(11) | VARCHAR2(11) NOT NULL | QDRO ID |
| 3 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 4 | COMMENT_DT |
Date(10) | DATE |
Comment Date
Default Value: %date |
| 5 | PA_COMMENT_SRC |
Character(1) | VARCHAR2(1) NOT NULL |
Original Source of Comments
0= 1=Copied from DRO Panel 2=From Old Communications Panel 3=From Old Status Panel Default Value: 0 |
| 6 | COMMENTS | Long Character | CLOB |
Comment
Default Value: PA_DRODAT.COMMENTS |