GPAR_LAYOUT_ROW(SQL Table) |
Index Back |
|---|---|
Layout Row definitionsLayout Row Definitions for Argentinean file reports. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPAR_LAYOUT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Layout Identificator. |
| 2 | GPAR_ROW_SEQUENCE |
Number(3,0) | SMALLINT NOT NULL | Layout Row Sequence |
| 3 | GPAR_ROW_DEP_ON | Number(3,0) | SMALLINT NOT NULL |
Dependent Row
Default Value: 0 |
| 4 | GPAR_ROW_LENGTH | Number(3,0) | SMALLINT NOT NULL |
Row Length
Default Value: 0 |
| 5 | GPAR_ROW_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
RowType
D=Detail H=Header T=Trail Default Value: H |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: GPAR_LAYOUT_ROW.DESCR50 |
| 8 | GPAR_REPR_TIMES | Number(2,0) | SMALLINT NOT NULL |
Number of times a row is reproduced within a layout file.
Default Value: 1 |
| 9 | GPAR_QRY_NAME | Character(30) | VARCHAR2(30) NOT NULL |
Query name
Prompt Table:
QRY_NAME_VW
|
| 10 | 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 Default Value: N |