COUNTRYPrompt Table: GPFR_AF_CNTY_VW
GPFR_AF_APPLPrompt Table: GPFR_AF_APPL_VW
RECNAMEPrompt Table: PSRECDEFN
Prompt Table: GPFR_AF_APSV_VW
GPFR_AD_APSE_VW(SQL View) |
Index Back |
|---|---|
ADS Entry - Appl rec securityApplication Framework ADS Entry - This record is used to retrieve a list of Records allowed for deletion (for security) 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 ,RECNAME ,GPFR_AF_VERSION ,LAST_UPDT_DTTM ,LAST_UPDT_OPRID FROM PS_GPFR_AF_APSERTY |
| # | 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 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
| 4 | GPFR_AF_VERSION | Character(18) | VARCHAR2(18) NOT NULL |
Application Framework object version.
Prompt Table: GPFR_AF_APSV_VW |
| 5 | LAST_UPDT_DTTM | DateTime(26) | TIMESTAMP | Last Updated Date-Time Stamp |
| 6 | LAST_UPDT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Updated User Name |