AR_RPT_VERSION(SQL Table) |
Index Back |
|---|---|
Report Version Control Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  REPORT_VERSION |
Character(10) | VARCHAR2(10) NOT NULL | Report Version |
| 2 | REPORT_PART_NUMBER |
Character(10) | VARCHAR2(10) NOT NULL | Part |
| 3 | REPORT_SECTION_NBR |
Character(3) | VARCHAR2(3) NOT NULL | Section |
| 4 | REPORT_LINE_NUMBER |
Character(3) | VARCHAR2(3) NOT NULL | Line |
| 5 | REPORT_PART_NAME | Character(200) | VARCHAR2(200) NOT NULL | Part Name |
| 6 | REPORT_SECTN_NAME | Character(200) | VARCHAR2(200) NOT NULL | Section Name |
| 7 | REPORT_LINE_NAME | Character(200) | VARCHAR2(200) NOT NULL | Line Name |
| 8 | DISPLAY_COUNT | Character(1) | VARCHAR2(1) NOT NULL | Display Count |
| 9 | DISPLAY_AMOUNT | Character(1) | VARCHAR2(1) NOT NULL | Display Amount |
| 10 | SEL_ENTRY_USE_ID | Character(1) | VARCHAR2(1) NOT NULL |
Select Entry Use Ids
N=Unselected Y=Selected Default Value: N |
| 11 | EXCL_ENTRY_USE_ID | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Entry Use Ids
N=Unselected Y=Selected Default Value: N |
| 12 | SEL_DELINQNCY_CD | Character(1) | VARCHAR2(1) NOT NULL |
Select Delinquency Code
N=Unselected Y=Selected Default Value: N |
| 13 | EXCL_DELINQNCY_CD | Character(1) | VARCHAR2(1) NOT NULL |
Exclude Delinquency Code
N=Unselected Y=Selected Default Value: N |
| 14 | CALCULATION | Character(1) | VARCHAR2(1) NOT NULL |
Calculation
N=Unselected Y=Selected Default Value: N |
| 15 | INCLD_IN_FOOTNOTE | Character(1) | VARCHAR2(1) NOT NULL |
Include in Footnotes
Y=Selected Default Value: N |
| 16 | DISPLAY_CONTROL1 | Number(3,0) | SMALLINT NOT NULL |
Display Control 1
Default Value: 1 |
| 17 | DISPLAY_CONTROL2 | Number(3,0) | SMALLINT NOT NULL |
Display Control 2
Default Value: 1 |
| 18 | SUBLINE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subline Flag
L=Line S=Subline |
| 19 | AMOUNT_SIGN | Character(1) | VARCHAR2(1) NOT NULL |
Amount Sign
N=Normal R=Reversed |