GP_ABS_RECDTL(SQL Table) |
Index Back |
---|---|
Template Field Setup TableConfigurable Sections: The Template Field Setup Table is a child of the Template Record Setup Table and will contain one row for each enterable field currently included in the core Absence processes. These will be the fields available to be included in the template sections. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: GP_ABS_RECDEFN |
2 | INSTANCE | Number(3,0) | SMALLINT NOT NULL |
Instance Number
Default Value: 1 |
3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: GP_ABS_FLDKPVW |
4 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |