GP_ABS_RECDEFN (SQL Table)	Index Back
Template Record Setup Table Configurable Sections: The Template Record Setup Table will simply contain one row for each table currently included in the core Absence processes with at least one enterable field.

GP_ABS_RECDEFN

(SQL Table)

Template Record Setup Table

Configurable Sections: The Template Record Setup Table will simply contain one row for each table currently included in the core Absence processes with at least one enterable field.

Parent Record Of GP_ABS_RECDTL

# 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_CS_RECVW

2 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
Default Value: 1

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 ALIAS_TBL_NAME Character(18) VARCHAR2(18) NOT NULL Alias Table Name

5 GP_ABS_CS_USE_ONLY Character(1) VARCHAR2(1) NOT NULL Configurable Sections Setup.
Y/N Table Edit
Default Value: N

6 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N

#	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_CS_RECVW
2	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number Default Value: 1
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	ALIAS_TBL_NAME	Character(18)	VARCHAR2(18) NOT NULL	Alias Table Name
5	GP_ABS_CS_USE_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Configurable Sections Setup. Y/N Table Edit Default Value: N
6	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N