GPFR_DA_REC_AET(SQL Table) |
Index Back |
---|---|
UPGRADE State RecordGPFR UPGRADE State Record used by DADS app engine |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | GPFR_DA_STRUCT | Character(10) | VARCHAR2(10) NOT NULL | DADS related field |
3 | GPFR_DA_RECORD | Character(10) | VARCHAR2(10) NOT NULL | DADS related record |
4 | GPFR_DA_DESCR | Character(60) | VARCHAR2(60) NOT NULL | DADS related field |
5 | GPFR_DA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
A=Active I=Inactive Default Value: A |
6 | GPFR_DA_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
D=Display Only E=Edit I=Invisible Default Value: E |
7 | GPFR_DA_MANDATORY | Character(1) | VARCHAR2(1) NOT NULL |
DADs related field
Y/N Table Edit Default Value: N |
8 | GPFR_DA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
F=Fixed M=Monetary N=Numeric T=Text Default Value: T |
9 | GPFR_DA_LENGTH | Number(3,0) | SMALLINT NOT NULL | DADS related field |
10 | GPFR_DA_DECIMAL | Number(2,0) | SMALLINT NOT NULL | DADS related field |
11 | GPFR_DA_LBLSRC | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
1=Data Type 2=Record 3=Translate Value |
12 | GPFR_DA_DATTYP | Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table: GPFR_DA_DATTYP |
13 | GPFR_DA_PROMPT | Character(15) | VARCHAR2(15) NOT NULL |
DADS related field
Prompt Table: RECDEFN_VW |
14 | GPFR_DA_PR_KEY | Character(15) | VARCHAR2(15) NOT NULL | DADS related field |
15 | GPFR_DA_PR_DESC | Character(15) | VARCHAR2(15) NOT NULL | DADS related field |
16 | GPFR_DA_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
DADS related field
Prompt Table: PSDBFIELD_VW |
17 | 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: 6 |
18 | GPFR_DA_SUMOPT | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
1=Sum 2=First 3=Last |
19 | GPFR_DA_CUSTOM | Character(1) | VARCHAR2(1) NOT NULL |
DADS Customization Flag
C=Customization P=PeopleSoft Maintained Default Value: C |
20 | GPFR_DA_AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | DADS Application Engine Section |
21 | GPFR_DA_FIXED | Character(20) | VARCHAR2(20) NOT NULL | Fixed Text |
22 | GPFR_DA_SIGN_IND | Character(1) | VARCHAR2(1) NOT NULL |
Sign Indicator
A=Add S=Subtract Y/N Table Edit |
23 | 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. |
24 | 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. |
25 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |