| # |
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_FLD_SEQUENCE |
Number(4,0) |
SMALLINT NOT NULL |
Field sequence in a given row and layout.
|
| 4 |
GPAR_QRY_ALIAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Alias Query linked to a field
|
| 5 |
GPAR_FIELD_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Unique field name used in query definitions. Includes alias table.
|
| 6 |
GPAR_QRY_FLD_SEQ |
Number(4,0) |
SMALLINT NOT NULL |
Query field sequence, maps the sequence of columns in a query.
|
| 7 |
DESCR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Description of length 50
|
| 8 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: GPAR_LAYOUT_FLD.DESCR50
|
| 9 |
GPAR_FIELD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field Type
0=Character
1=Long Char
2=Numeric
3=Signed Number
4=Date
5=Time
6=Date Time
7=Image
Default Value: 0
|
| 10 |
GPAR_BREAK_DATA |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if an agent count should be triggered.
Y/N Table Edit
Default Value: N
|
| 11 |
REQUIRED_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
* Required Field
Y/N Table Edit
Default Value: N
|
| 12 |
GPAR_START_POSN |
Number(3,0) |
SMALLINT NOT NULL |
Field start position in a row
|
| 13 |
GPAR_FIELD_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
Field Layout Length
|
| 14 |
GPAR_DECIMALS |
Number(2,0) |
SMALLINT NOT NULL |
Stores the number of decimals to be displayed in a layout
|
| 15 |
GPAR_FIELD_VALUE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines the field source value, which may be from the field data, user default, conversion or an agent.
A=Agent Value
C=Conversion
D=User Default
S=Field Data
|
| 16 |
GPAR_DEFAULT_VALUE |
Character(100) |
VARCHAR2(100) NOT NULL |
Stores the field default value that is related to a field value.
|
| 17 |
GPAR_DATE_FORMAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Field to store date format based on DD for day, MM for month, YYYY for year.
01=DDMMYY
02=DDMMYYYY
03=DDMMMYY
04=DDMMMYYYY
05=MMDDYY
06=MMDDYYYY
07=MMMDDYY
08=MMMDDYYYY
09=YYMMDD
10=YYMMMDD
11=YYYYMMDD
12=YYYYMMMDD
Default Value: 02
|
| 18 |
GPAR_TIME_FORMAT |
Character(2) |
VARCHAR2(2) NOT NULL |
Field to store date format based on HH for hours MM for minutes, SS for seconds.
01=HHMMSS
02=HHMM
Default Value: 01
|
| 19 |
GPAR_DELIMIT_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Character used as delimiter in date construction to separate day, month and year.
|
| 20 |
GPAR_LPAD_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Pad character used in a layout field
|
| 21 |
GPAR_RPAD_CHAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Pad character used in a layout field
|
| 22 |
GPAR_UPPERCASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Convert to UpperCase
Y/N Table Edit
Default Value: N
|
| 23 |
GPAR_STRIP_CHARS |
Character(10) |
VARCHAR2(10) NOT NULL |
Characters to be stripped out from a field string.
|
| 24 |
GPAR_FIELD_SUPRESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to store if a field has to be suppresed in the layout.
Y/N Table Edit
Default Value: N
|
| 25 |
GPAR_LOG_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine if a field should be displayed in the log file or not
Y/N Table Edit
Default Value: N
|
| 26 |
GPAR_LTRIM_SPACES |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove blank characters from the left of a string
Y/N Table Edit
Default Value: N
|
| 27 |
GPAR_RTRIM_SPACES |
Character(1) |
VARCHAR2(1) NOT NULL |
Remove blank characters from the right of a string
Y/N Table Edit
Default Value: N
|
| 28 |
GPAR_FIELD_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field source
Q=From Query
U=From User
Default Value: U
|
| 29 |
GPAR_AGENT_VALUE |
Character(2) |
VARCHAR2(2) NOT NULL |
Stores the agent value to be used
01=Get Sum Field
02=Get Count Field
03=Get Current Date
04=Get Current Time
|
| 30 |
GPAR_AGENT_FIELD |
Character(30) |
VARCHAR2(30) NOT NULL |
Unique field name used in query definition, includes alias table.
Prompt Table:
GPAR_AGENTS_VW
|
| 31 |
GPAR_AGENT_COUNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if an agent count should be triggered
Y/N Table Edit
Default Value: N
|
| 32 |
GPAR_AGENT_SUM |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if an agent sum should be triggered.
Y/N Table Edit
Default Value: N
|
| 33 |
GPAR_AGENT_RST_VAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates if an agent count should be triggered.
Y/N Table Edit
Default Value: N
|
| 34 |
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
|