ACD_STAT_TP_DTL (SQL Table)	Index Back
Acad Statistics Type Detail This table will contail all valid program statuses that will be valid for a specific academic statistics type.

ACD_STAT_TP_DTL

(SQL Table)

Acad Statistics Type Detail

This table will contail all valid program statuses that will be valid for a specific academic statistics type.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACAD_STATS_PD_TYPE Character(2) VARCHAR2(2) NOT NULL Statistics Period Type

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

3 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
AC=Active in Program
AD=Admitted
AP=Applicant
CM=Completed Program
CN=Cancelled
DC=Discontinued
DE=Deceased
DM=Dismissed
LA=Leave of Absence
PM=Prematriculant
SP=Suspended
WT=Waitlisted

4 SSR_INCL_TERM_ACTV Character(1) VARCHAR2(1) NOT NULL This field is used to identify if a student ACAD_PROG record should be included in consolidated statistics if the program status is not active but the student is term activated.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACAD_STATS_PD_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Statistics Period Type
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	PROG_STATUS	Character(4)	VARCHAR2(4) NOT NULL	Academic Program Status AC=Active in Program AD=Admitted AP=Applicant CM=Completed Program CN=Cancelled DC=Discontinued DE=Deceased DM=Dismissed LA=Leave of Absence PM=Prematriculant SP=Suspended WT=Waitlisted
4	SSR_INCL_TERM_ACTV	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if a student ACAD_PROG record should be included in consolidated statistics if the program status is not active but the student is term activated. Y/N Table Edit Default Value: N