GPBR_NRP_LOA_AD (SQL Table)	Index Back
Brazil Loans Brazil Loans

GPBR_NRP_LOA_AD

(SQL Table)

Brazil Loans

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

5 GPBR_LOAN_NUM Character(10) VARCHAR2(10) NOT NULL Loan Number

6 START_DT Date(10) DATE Start Date

7 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.

8 GPBR_TOT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Total Amount

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
5	GPBR_LOAN_NUM	Character(10)	VARCHAR2(10) NOT NULL	Loan Number
6	START_DT	Date(10)	DATE	Start Date
7	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
8	GPBR_TOT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total Amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code