SSR_ADC_RSLT_VW

(SQL View)
 Index Back

Activity Action Date Ctrl Cont

Activity Action Date Control by Content Type

SELECT SSR_AC_CONTX_TYPE , SSR_ADC_RSLTREL_TP , SSR_ADC_RSLT_ID , EFFDT , SSR_AC_CONTENT_TP , SSR_ADC_RSLT_TYPE , SSR_ADC_START_ID , SSR_ADC_START_ADJ , SSR_ADC_START_SRCE , SSR_ADC_START_TIME , SSR_ADC_END_ID , SSR_ADC_TRM_PER_AD , SSR_ADC_END_ADJ , SSR_ADC_END_SRCE , SSR_ADC_END_TIME , SSR_ADC_RSLT_STAT , SSR_ADC_RSLT_HIST FROM PS_SSR_ADC_RSLT_CO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
CRSE=Coursework
2 SSR_ADC_RSLTREL_TP Character(2) VARCHAR2(2) NOT NULL Release Type
FS=Faculty Self Service Update
SS=Student Self Service View
3 SSR_ADC_RSLT_ID Character(20) VARCHAR2(20) NOT NULL Result Date ID
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type

Prompt Table: SSR_AC_ITEMTYPE

6 SSR_ADC_RSLT_TYPE Character(2) VARCHAR2(2) NOT NULL Result Access
C=Calculating
DR=Display Results
G=Grading
7 SSR_ADC_START_ID Character(20) VARCHAR2(20) NOT NULL Start Date Source

Prompt Table: SSR_ADC_RSLSTVW

8 SSR_ADC_START_ADJ Signed Number(4,0) DECIMAL(3) NOT NULL Adjust Start Date
9 SSR_ADC_START_SRCE Character(1) VARCHAR2(1) NOT NULL Use Time From Start Source

Y/N Table Edit

Default Value: N

10 SSR_ADC_START_TIME Time(15) TIMESTAMP Start Time

Default Value: 00:00:00

11 SSR_ADC_END_ID Character(20) VARCHAR2(20) NOT NULL End Date Source

Prompt Table: SSR_ADC_RSLENVW

12 SSR_ADC_TRM_PER_AD Number(3,0) SMALLINT NOT NULL Adjust End Term/Period
13 SSR_ADC_END_ADJ Signed Number(4,0) DECIMAL(3) NOT NULL Adjust End Date
14 SSR_ADC_END_SRCE Character(1) VARCHAR2(1) NOT NULL Use Time From End Source

Y/N Table Edit

Default Value: N

15 SSR_ADC_END_TIME Time(15) TIMESTAMP End Time

Default Value: 23:59:00

16 SSR_ADC_RSLT_STAT Character(1) VARCHAR2(1) NOT NULL Display Result Status

Y/N Table Edit

Default Value: Y

17 SSR_ADC_RSLT_HIST Character(1) VARCHAR2(1) NOT NULL Display Result History

Y/N Table Edit

Default Value: N