ART_REPORT_IDPrompt Table: PSMSGSETDEFN
Prompt Table: PSMSGCATDEFN
P=Buffer Rowset
Q=PeopleSoft Query
R=Record / View
Default Value: Q
C=Chart
I=Info Card
Default Value: C
ART_REPORT_DFN(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ART_REPORT_ID |
Character(18) | VARCHAR2(18) NOT NULL | ART Report ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 4 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN |
| 5 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |
| 6 | ART_SOURCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Source Data Type
P=Buffer Rowset Q=PeopleSoft Query R=Record / View Default Value: Q |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 8 | QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 9 | ART_ROWSET_NAME | Character(18) | VARCHAR2(18) NOT NULL | Source Rowset Name |
| 10 | ART_DISPLAY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Display Type
C=Chart I=Info Card Default Value: C |
| 11 | OWNER_ID | Character(5) | VARCHAR2(5) NOT NULL | Owner ID |