RB_TEMP_PACK_VW(SQL View) |
Index Back |
|---|---|
Template PackagesUsed for ERMS Reports. Lists all Template packages. |
| SELECT A.RB_PACKAGE_NAME , A.MAILBOX_ID , A.ROW_ADDED_DTTM , A.SEND_DATE FROM PS_RB_NONTEMPUSG_V A WHERE A.RB_PACKAGE_NAME NOT IN ( SELECT B.RB_PACKAGE_NAME FROM PS_RB_TMPACKUSG_VW B) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RB_PACKAGE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 2 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 3 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 4 | SEND_DATE | Date(10) | DATE | Correspondence Send Date |