| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GPFR_DA_STRUCT |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
|
| 2 |
GPFR_DA_RECORD |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related record
|
| 3 |
GPFR_DA_DESCR |
Character(60) |
VARCHAR2(60) NOT NULL |
DADS related field
|
| 4 |
GPFR_DA_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
A=Active
I=Inactive
Default Value: A
|
| 5 |
GPFR_DA_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
D=Display Only
E=Edit
I=Invisible
Default Value: E
|
| 6 |
GPFR_DA_MANDATORY |
Character(1) |
VARCHAR2(1) NOT NULL |
DADs related field
Y/N Table Edit
Default Value: N
|
| 7 |
GPFR_DA_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
F=Fixed
M=Monetary
N=Numeric
T=Text
Default Value: T
|
| 8 |
GPFR_DA_LENGTH |
Number(3,0) |
SMALLINT NOT NULL |
DADS related field
|
| 9 |
GPFR_DA_DECIMAL |
Number(2,0) |
SMALLINT NOT NULL |
DADS related field
|
| 10 |
GPFR_DA_LBLSRC |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
1=Data Type
2=Record
3=Translate Value
|
| 11 |
GPFR_DA_DATTYP |
Character(10) |
VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table:
GPFR_DA_DATTYP
|
| 12 |
GPFR_DA_PROMPT |
Character(15) |
VARCHAR2(15) NOT NULL |
DADS related field
Prompt Table:
RECDEFN_VW
|
| 13 |
GPFR_DA_PR_KEY |
Character(15) |
VARCHAR2(15) NOT NULL |
DADS related field
|
| 14 |
GPFR_DA_PR_DESC |
Character(15) |
VARCHAR2(15) NOT NULL |
DADS related field
|
| 15 |
GPFR_DA_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
DADS related field
Prompt Table:
PSDBFIELD_VW
|
| 16 |
GPFR_DA_DATSRC |
Character(2) |
VARCHAR2(2) NOT NULL |
DADS related field
0=System-Computed
1=Accumulator User Key 1
10=Base
11=Percent
12=Rate
13=Unit
14=Customer Field1
15=Customer Field2
16=Customer Field3
17=Customer Field4
18=Customer Field5
2=Accumulator User Key 2
3=Accumulator User Key 3
4=Accumulator User Key 4
5=Payroll Result Value
6=Fixed Text
7=Not Computed
8=Accumulator User Key 5
9=Accumulator User Key 6
Default Value: 7
|
| 17 |
GPFR_DA_SUMOPT |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS related field
1=Sum
2=First
3=Last
|
| 18 |
GPFR_DA_CUSTOM |
Character(1) |
VARCHAR2(1) NOT NULL |
DADS Customization Flag
C=Customization
P=PeopleSoft Maintained
Default Value: C
|
| 19 |
GPFR_DA_AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
DADS Application Engine Section
|
| 20 |
GPFR_DA_FIXED |
Character(20) |
VARCHAR2(20) NOT NULL |
Fixed Text
|
| 21 |
GPFR_DA_SIGN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Indicator
A=Add
S=Subtract
Y/N Table Edit
|
| 22 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 23 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|