PA_QDRO_COMNOTE

(SQL Table)
Index Back

QDRO Related Documents

This 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 QDRO_DOC_DT Date(10) DATE Date a QDRO document sent/recv
4 PA_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
5 COMMENT_DT Date(10) DATE Comment Date

Default Value: %date

6 COMMENT_SEQ_NUM Number(4,0) SMALLINT NOT NULL Comment Date Sequence Number
7 COMMENTS Long Character CLOB Comment