EOBF_REPORT(SQL Table) |
Index Back |
|---|---|
BAM report characteristicsBAM report characteristics |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | BAM Interactive Report ID | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | EOLT_PRODUCT_CODE | Character(4) | VARCHAR2(4) NOT NULL | Unique code for a product. |
| 4 | EOBF_MDL_FILE_NAME | Character(254) | VARCHAR2(254) NOT NULL | BAM model file name |
| 5 | EOBF_PV_FILE_NAME | Character(254) | VARCHAR2(254) NOT NULL | BAM pageview file name |
| 6 | EOBF_ENABL_RPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
BAM report enabled flag
Y/N Table Edit Default Value: N |
| 7 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit |
| 8 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |
| 9 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 10 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |