PSDOCTPLMEDIA(SQL Table) |
Index Back |
---|---|
Document Template Media Query |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | IB_DOCTMPLNAME | Character(30) | VARCHAR2(30) NOT NULL | Template Name (see PSDOCTPLDEFN). |
2 | IB_MEDIA_QUERY_NM | Character(30) | VARCHAR2(30) NOT NULL | Media Query Name |
3 | IB_COMMENTS | Character(200) | VARCHAR2(200) NOT NULL | Comments |
4 | IBTRANSACTIONID | Character(36) | VARCHAR2(36) NOT NULL | Transaction ID |
5 | IB_MEDIA_QRY_DATA | Long Character | CLOB | Media Query |