GPFR_AF_DPM_IMP

(SQL Table)
Index Back

Function and Parameter list

Application Framework - This record is used in DON definition and it contains all the function and parameter names defined in associated SQL entity

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application
3 GPFR_AF_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Data Object Name
4 GPFR_AF_SQL_SEQ Number(8,0) INTEGER NOT NULL Application Framework - SQL Sequence
5 GPFR_AF_PARM_SEQ Number(8,0) INTEGER NOT NULL Application Framework - PARM Sequence

Default Value: 99999999

6 GPFR_AF_FUNCT_NM Character(16) VARCHAR2(16) NOT NULL Application Framework - Function
7 GPFR_AF_PARM_NM Character(20) VARCHAR2(20) NOT NULL Application Framework - Parameter
8 GPFR_AF_DON_SRCTYP Character(3) VARCHAR2(3) NOT NULL Application Framework - DON Source Type
CHR=Character
DAT=Date
FLD=Primary RecFld
FLS=Secondary RecFld
MAP=Mapping Code
NUM=Number
SQL=SQL
SYS=System

Default Value: SYS

9 GPFR_AF_INPUT_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Input Field

Prompt Table: GPFR_AF_ENT_DVW

10 GPFR_AF_PROMPT_REC Character(20) VARCHAR2(20) NOT NULL Application Framework - Source Prompt Record

Prompt Table: GPFR_AF_SRRC_VW

11 GPFR_AF_CODE_ID Character(12) VARCHAR2(12) NOT NULL Application Framework - Code ID

Prompt Table: GPFR_AF_COD_DVW

12 GPFR_AF_OVRR_IND Character(1) VARCHAR2(1) NOT NULL Application Framework - Allow Override
N=No Override
Y=Allow Override

Y/N Table Edit

Default Value: N

13 GPFR_AF_CHAR_VAL Character(50) VARCHAR2(50) NOT NULL Application Framework - Character
14 GPFR_AF_DATE_VAL Date(10) DATE Application Framework - Date
15 GPFR_AF_NUM_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Application Framework - Number
16 GPFR_AF_SQL_VAL Long Character CLOB Application Framework - SQL Data Value
17 GPFR_AF_OWNER Character(1) VARCHAR2(1) NOT NULL Application Framework - Object Owner
C=Customer Maintained
P=Peoplesoft Maintained
18 GPFR_AF_UPGRADE Character(1) VARCHAR2(1) NOT NULL Application Framework - Run Upgrade