AM_TEMPLATE_DET

(SQL Table)
Index Back

Template Detail

Template Detail

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AM_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template ID
2 AM_COL_SEQ Number(3,0) SMALLINT NOT NULL Column Sequence
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: AM_IMP_PROMPT

5 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

Y/N Table Edit

Default Value: N

6 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
N=Inactive
Y=Active

Y/N Table Edit

Default Value: N

7 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
8 AM_SEQ2_REQ_FLG Character(1) VARCHAR2(1) NOT NULL Sequence 2 Required Flag

Y/N Table Edit

Default Value: N