PAY_CALENDR_NLD

(SQL Table)
Index Back

Pay Calendar

The Pay Calendar record contains cycles for oayroll processing created for Pay Groups.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
4 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

Prompt Table: PAY_RUN_TBL

5 PAY_BEGIN_DT Date(10) DATE NOT NULL Pay Period Begin Date
6 CHECK_DT Date(10) DATE Check date.
7 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
8 MONTHCD Character(2) VARCHAR2(2) NOT NULL Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
9 PAY_CALC_RUN Character(1) VARCHAR2(1) NOT NULL Payroll Calculation Run

Y/N Table Edit

Default Value: N

10 NL_NBR_OF_WORKDAYS Number(3,0) SMALLINT NOT NULL Number of workdays
11 NL_PRODUCTION_CD Character(2) VARCHAR2(2) NOT NULL Production Code
12 NL_TXT_PAYMENT_ORD Character(64) VARCHAR2(64) NOT NULL Text Payment Order