GPBR_MANAD_RUNT (SQL Table)	Index Back
MANAD Parameters BRA MANAD Parameters BRA

GPBR_MANAD_RUNT

(SQL Table)

MANAD Parameters BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
Prompt Table: GPBR_ESTAB2_VW

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
Prompt Table: GP_RUN_TYPE2_VW

4 GPBR_RUN_TYPE_ID Character(1) VARCHAR2(1) NOT NULL Run Type ID
1=1-Regular Payroll
2=2-13th Salary
3=3-Vacations
4=4-Complementary Payroll
5=5-Complementary 13 Salary
6=6-Other
Default Value: 1

5 GPBR_RUN_TYPE_TERM Character(1) VARCHAR2(1) NOT NULL Flag to identify Termination Run Types
1=1-Regular Payroll
2=2-13th Salary
3=3-Vacations
4=4-Complementary Payroll
5=5-Complementary 13 Salary
6=6-Other
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: GPBR_ESTAB2_VW
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name Prompt Table: GP_RUN_TYPE2_VW
4	GPBR_RUN_TYPE_ID	Character(1)	VARCHAR2(1) NOT NULL	Run Type ID 1=1-Regular Payroll 2=2-13th Salary 3=3-Vacations 4=4-Complementary Payroll 5=5-Complementary 13 Salary 6=6-Other Default Value: 1
5	GPBR_RUN_TYPE_TERM	Character(1)	VARCHAR2(1) NOT NULL	Flag to identify Termination Run Types 1=1-Regular Payroll 2=2-13th Salary 3=3-Vacations 4=4-Complementary Payroll 5=5-Complementary 13 Salary 6=6-Other Y/N Table Edit Default Value: N