GPFR_AF_AT_VW

(SQL View)
 Index Back

Attribute Record

Application Framework - This is the base Attribute Record. This record Stores all the attributes along with their properties.

SELECT COUNTRY ,GPFR_AF_APPL ,GPFR_AF_KEY_NODE ,GPFR_AF_KEY_ATTR ,GPFR_AF_ATTR_NAME ,GPFR_AF_ATTR_STAT ,GPFR_AF_ATTR_SEQ ,DESCR60 ,GPFR_AF_ATTR_TYPE ,GPFR_AF_ATR_LENGTH ,GPFR_AF_ATR_DECIML ,GPFR_AF_MANDATORY ,GPFR_AF_ATR_LBLSRC ,GPFR_AF_CODE_ID ,GPFR_AF_PROMPT ,GPFR_DA_DATTYP ,GPFR_AF_PR_LBL_FLD ,GPFR_AF_PR_KEY_FLD ,GPFR_AF_ATTR_FIELD ,GPFR_AF_PS_DON ,GPFR_AF_CUST_DON ,COMMENTS ,GPFR_AF_OWNER ,'Y' FROM PS_GPFR_AF_ATTR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application

Prompt Table: GPFR_AF_APPL

3 GPFR_AF_KEY_NODE Number(8,0) INTEGER NOT NULL Application Framework - Key Node

Prompt Table: GPFR_AF_NODE

4 GPFR_AF_KEY_ATTR Number(8,0) INTEGER NOT NULL Application Framework - Key Attribute

Default Value: 99999999

5 GPFR_AF_ATTR_NAME Character(12) VARCHAR2(12) NOT NULL Application Framework - Attribute Name
6 GPFR_AF_ATTR_STAT Character(1) VARCHAR2(1) NOT NULL Application Framework - Attribute Status
A=Active
I=Inactive

Default Value: A

7 GPFR_AF_ATTR_SEQ Number(4,0) SMALLINT NOT NULL Application Framework - Attribute Sequence
8 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
9 GPFR_AF_ATTR_TYPE Character(1) VARCHAR2(1) NOT NULL Application Framework - *Attribute Type
D=Date
M=Monetary
N=Numeric
T=Text
10 GPFR_AF_ATR_LENGTH Number(3,0) SMALLINT NOT NULL Application Framework - *Attribute Length
11 GPFR_AF_ATR_DECIML Number(2,0) SMALLINT NOT NULL Application Framework - Attribute Decimal
12 GPFR_AF_MANDATORY Character(1) VARCHAR2(1) NOT NULL Application Framework - Mandatory

Y/N Table Edit

Default Value: N

13 GPFR_AF_ATR_LBLSRC Character(4) VARCHAR2(4) NOT NULL Application Framework - Attribute Label Source
CODE=Code ID
DTYP=Data Type
RECD=Record
XLAT=Xlat Value
14 GPFR_AF_CODE_ID Character(12) VARCHAR2(12) NOT NULL Application Framework - Code ID

Prompt Table: GPFR_AF_CODE_VW

15 GPFR_AF_PROMPT Character(15) VARCHAR2(15) NOT NULL Application Framework - Edit Table

Prompt Table: RECDEFN_VW

16 GPFR_DA_DATTYP Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: GPFR_DA_DATTYP

17 GPFR_AF_PR_LBL_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Label Field Name

Prompt Table: GPFR_AF_FLD_DVW

18 GPFR_AF_PR_KEY_FLD Character(18) VARCHAR2(18) NOT NULL Application Framework - Prompt Key Field Name

Prompt Table: GPFR_AF_FLD_DVW

19 GPFR_AF_ATTR_FIELD Character(18) VARCHAR2(18) NOT NULL Application Framework - Field Name

Prompt Table: GPFR_AF_DBFLDVW

20 GPFR_AF_PS_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Peoplesoft Data Object Name

Prompt Table: GPFR_AF_PDON_VW

21 GPFR_AF_CUST_DON Character(16) VARCHAR2(16) NOT NULL Application Framework - Customer Data Object Name

Prompt Table: GPFR_AF_CDON_VW

22 COMMENTS Long Character CLOB Comment
23 GPFR_AF_OWNER Character(1) VARCHAR2(1) NOT NULL Application Framework - Object Owner
C=Customer Maintained
P=Peoplesoft Maintained
24 GPFR_AF_UPGRADE Character(1) VARCHAR2(1) NOT NULL Application Framework - Run Upgrade