CA_SEC_TMPL_FLD

(SQL Table)
Index Back

Validation Fields

List of fields to be validated

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: CA_SEC_CMP_VW

4 MARKET Character(3) VARCHAR2(3) NOT NULL Market
5 COMBINATION_NO Number(3,0) SMALLINT NOT NULL Combination Number
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
8 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
9 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
10 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
11 PTCS_PNLFLDNAME Character(254) VARCHAR2(254) NOT NULL Page Field Name