GL_GEN_DT_VW

(SQL View)
Index Back

General Date View

General Date View

select company, paygroup, pay_end_dt, gl_gen_status from PS_GL_GEN_HISTORY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 PAY_END_DT Date(10) DATE Pay Period End Date
4 GL_GEN_STATUS Character(1) VARCHAR2(1) NOT NULL GL Generation Status
D=Dispatched to GL
N=New Entries Generated
P=Processed by Journal Generator