REPORT_REQUEST_NBRPrompt Table: SA_REQUEST_HDR
REQUEST_SEQ_NBRPrompt Table: SA_REQUEST_DTL
REPORT_NUMBERREPORT_LINE_NBRSA_REPORT_RSLT(SQL Table) |
Index Back |
|---|---|
Report ResultsThis table contains the output from the report process initiated from a report request. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | REPORT_REQUEST_NBR |
Character(9) | VARCHAR2(9) NOT NULL |
Report Request Nbr
Prompt Table: SA_REQUEST_HDR |
| 2 | REQUEST_SEQ_NBR |
Number(5,0) | INTEGER NOT NULL |
Request Seq Nbr
Prompt Table: SA_REQUEST_DTL |
| 3 | REPORT_NUMBER |
Number(2,0) | SMALLINT NOT NULL | Report Number |
| 4 | REPORT_LINE_NBR |
Number(4,0) | SMALLINT NOT NULL | Report Line Number |
| 5 | TSCRPT_COMP_CODE | Character(5) | VARCHAR2(5) NOT NULL | Transcript Component Code |
| 6 | DISPLAY_ATTR | Character(3) | VARCHAR2(3) NOT NULL | Display Attributes |
| 7 | TSCRPT_COMP_DATA | Character(90) | VARCHAR2(90) NOT NULL | Transcript Component Data |