GP_ABS_PG0SCVW

(SQL View)
Index Back

Template Section View

Configurable Sections: View against the Template Section Setup table returning only the page zero configuration sections.

SELECT COUNTRY , GP_ABS_CS_SEC_ID , SEQ_NBR FROM PS_GP_ABS_SECDEFN WHERE GP_ABS_CS_SEC_ID IN ('TBH_PAGE_ZERO', 'TBH_PAGE_ZERO_FED') AND COUNTRY = 'USA'

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

Prompt Table: GP_COUNTRY

2 GP_ABS_CS_SEC_ID Character(18) VARCHAR2(18) NOT NULL Template Section ID
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

Default Value: 1