| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ALIAS_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Alias Name
|
| 2 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 3 |
LOOKUP_TABLE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup Value Aliases
1=One Dimensional
2=Two Dimensional
Default Value: 1
|
| 4 |
TL_TBL_1ST_COL_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
lookup table 1st column name
|
| 5 |
TL_TBL_1ST_COL_PIC |
Character(10) |
VARCHAR2(10) NOT NULL |
lookup table 1st col picture
|
| 6 |
TL_TBL_2ND_COL_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
lookup table 2nd column name
|
| 7 |
TL_TBL_2ND_COL_PIC |
Character(10) |
VARCHAR2(10) NOT NULL |
lookup table 2nd col picture
|
| 8 |
TL_TBL_3RD_COL_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
lookup table 3rd column name
|
| 9 |
TL_TBL_3RD_COL_PIC |
Character(10) |
VARCHAR2(10) NOT NULL |
lookup table 3rd col picture
|
| 10 |
TL_LKUP1_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Alias or Internal linkage
A=Use Alias
I=Program Generated
Default Value: A
|
| 11 |
TL_LKUP1_ALIAS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Alias name if alias type
Prompt Table:
PA_TBL_ALS_VW
|
| 12 |
TL_LKUP1_ALIAS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Alias type
|
| 13 |
TL_LKUP2_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Alias or Internal Pgm Generate
A=Alias Resolved
I=Internal Program Generation
N=Not Applicable (One Way Tbl)
|
| 14 |
TL_LKUP2_ALIAS_NM |
Character(10) |
VARCHAR2(10) NOT NULL |
Alias name if 'alias' type
Prompt Table:
PA_TBL_ALS_VW
|
| 15 |
TL_LKUP2_ALIAS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Alilas type
|
| 16 |
TL_RSLT_RND_MTHD |
Character(10) |
VARCHAR2(10) NOT NULL |
Tbl lookup rslt rnd method
Prompt Table:
PA_DATE_RND_OPT
|
| 17 |
TL_RSLT_NUM_RND_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Numeric Result Round Code
N=None
U=Round Numeric Result Up
Default Value: N
|
| 18 |
INTERPOLATE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Bracket Interpolation Method
H=Use Next Higher
I=Linear
L=Use Next Lower
N=Use Nearest
|
| 19 |
TOO_LOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup Value is Below Minimum
E=Error - End Calculation
U=Use Minimum Value
Default Value: U
|
| 20 |
TOO_HIGH |
Character(1) |
VARCHAR2(1) NOT NULL |
Lookup Value is Above Maximum
E=Error - End Calculation
U=Use Maximum
Default Value: U
|
| 21 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 22 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|