COUNTRYPrompt Table: GPFR_AF_CNTY_VW
GPFR_AF_APPLPrompt Table: GPFR_AF_APPL_VW
GPFR_DA_DATTYPPrompt Table: GPFR_DATA_TYPES
GPFR_AF_APPL_VERPrompt Table: GPFR_AF_AVER_V
GPFR_DA_CODEPrompt Table: GPFR_DT_VALUES
Prompt Table: GPFR_AF_DTVV_VW
GPFR_AD_DTVA_VW(SQL View) |
Index Back |
|---|---|
ADS Entry - Data Type ValuesApplication Framework ADS Entry - This record is used to retrieve a list of Data Type Value rows when searching for rows to be included in an ADS package. It also enhance the search of rows providing prompt tables for the search fields. |
| SELECT COUNTRY ,GPFR_AF_APPL ,GPFR_DA_DATTYP ,GPFR_AF_APPL_VER ,GPFR_DA_CODE ,DESCR254 ,GPFR_AF_VERSION ,LAST_UPDT_DTTM ,LAST_UPDT_OPRID FROM PS_GPFR_DT_VALUES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GPFR_AF_CNTY_VW |
| 2 | GPFR_AF_APPL |
Character(10) | VARCHAR2(10) NOT NULL |
Application Framework - Application
Prompt Table: GPFR_AF_APPL_VW |
| 3 | GPFR_DA_DATTYP |
Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table: GPFR_DATA_TYPES |
| 4 | GPFR_AF_APPL_VER |
Number(8,0) | INTEGER NOT NULL |
Application Framework - Application
Prompt Table: GPFR_AF_AVER_V |
| 5 | GPFR_DA_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
DADS related field
Prompt Table: GPFR_DT_VALUES |
| 6 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 7 | GPFR_AF_VERSION | Character(18) | VARCHAR2(18) NOT NULL |
Application Framework object version.
Prompt Table: GPFR_AF_DTVV_VW |
| 8 | LAST_UPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated Date-Time Stamp |
| 9 | LAST_UPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated User Name |