CDM_FILTER_ARCH(SQL Table) |
Index Back |
|---|---|
Rpt Dist - Archived rpt filterThis record is used by the report distribution to filter archived reports. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ARCHIVE_DT |
Date(10) | DATE |
Archive Date
Prompt Table: CDM_ARCH_DT_VW |
| 2 | PT_FILTERUNIT | Character(1) | VARCHAR2(1) NOT NULL |
Filter Unit
0=All 1=Days 2=Hours 3=Minutes 4=Years Default Value: 1 |
| 3 | PT_FILTERVALUE | Number(4,0) | SMALLINT NOT NULL |
Filter Value
Default Value: 1 |
| 4 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL |
Process Type
Prompt Table: PMN_PRCSTYPE_VW |
| 5 | RPTDIR | Character(150) | VARCHAR2(150) NOT NULL | Report Directory |
| 6 | FILTERVALUE | Number(2,0) | SMALLINT NOT NULL |
Filter Value
Default Value: 0 |
| 7 | FILTERUNIT | Character(1) | VARCHAR2(1) NOT NULL |
Filter Unit
0=None 1=Days 2=Hours 3=Minutes Default Value: 1 |
| 8 | FROM_DT | Date(10) | DATE | From Date |
| 9 | TO_DT | Date(10) | DATE | To Date |
| 10 | PT_FILTERTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Filter Type
0=Last 1=Date Range 3=All Default Value: 0 |