RB_NONTEMPUSG_V(SQL View) |
Index Back |
|---|---|
Template PackagesUsed for ERMS Reports. Lists all Template packages. |
| SELECT RB_PACKAGE_NAME ,' ' ,ROW_ADDED_DTTM ,%DatePart(ROW_ADDED_DTTM) FROM PS_RBC_PACKAGE_DFN |
| # | 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 |