PSSIGNON_VW(SQL View) |
Index Back |
|---|---|
Authorized Signon Period |
| SELECT B.CLASSID , B.DAYOFWEEK , A.XLATSHORTNAME , LPAD(TO_CHAR (FLOOR(STARTTIME/60)) ,2 , '0') ||':'|| LPAD(TO_CHAR (STARTTIME-(FLOOR(STARTTIME/60)*60)) ,2 , '0') , LPAD(TO_CHAR (FLOOR(ENDTIME/60)) ,2 , '0') ||':'|| LPAD(TO_CHAR (ENDTIME-(FLOOR(ENDTIME/60)*60)) ,2 , '0') FROM PSXLATITEM A , PSAUTHSIGNON B WHERE A.FIELDNAME='DAY_OFWEEK' AND A.FIELDVALUE=TO_CHAR(B.DAYOFWEEK) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLASSID | Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 2 | DAYOFWEEK | Number(1,0) | SMALLINT NOT NULL | Day of Week |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SIGNON_START_TIME | Character(5) | VARCHAR2(5) NOT NULL | Start Time |
| 5 | SIGNON_END_TIME | Character(5) | VARCHAR2(5) NOT NULL | End Time |